|707||24 Jul 2014 @ 02:19 PDT||Database||Reply||Complex SQL Scenario||Can you provide SQLs to set up the test data please. Will make it easier to check the options.
How do you distinct rule 1 and 2 (e.g. rule 2 example data also is also comply to rule 1). Same is tr... |
|706||21 Jul 2014 @ 07:06 PDT||Database||Reply||How to check what values are passed to procedure call from qrylog table ?||you have to change your SP to log the information. Using queryband could be efficient
SET QUERY_BAND = "PROCEDURE_NAME=yourSP;PROCEDURE_IN_PARAM=param1name:param1value|param2name... |
|705||18 Jul 2014 @ 02:31 PDT||Database||Reply||SQL statement wanted||Try the following:
create table t1
(OUTLET_ID integer, DATE_ID date, QUALITY_FLAG integer
) no primary index ;
insert into t1 values (1,date-5,1);
insert into t1 values (1,dat... |
|704||17 Jul 2014 @ 04:43 PDT||Database||Reply||Group by on a Group by not working as expected!!!||Can you explain why you think you need the two group by?
What is the difference to
SELECT EXTRACT(YEAR FROM D) AS Y, SUM(V) AS V
GROUP BY Y
|703||08 Jul 2014 @ 12:36 PDT||Database||Reply||Can we able to perform all the ETL activites by using VIEWS ?????||Check you TASM setting and discuss it with your DBAs
|702||08 Jul 2014 @ 12:32 PDT||General||Reply||teradata viewpoint from SQL assitanct||check dieters comment at http://forums.teradata.com/forum/database/active-running-queries
|701||08 Jul 2014 @ 12:25 PDT||General||Reply||time difference in minutes||this should do
select cast('2014-06-16 23:33:52' as timestamp(0)) a,
cast('2014-06-16 22:36:22' as timestamp(0)) b,
a-b Minute(4) to Second c,
extract(minute from c) + e... |
|700||03 Jul 2014 @ 06:27 PDT||General||Reply||If we see a GTT table definition,there is a LOG.Can anyone please tell me.||From the documentation:
whether transient journaling occurs for a global temporary or volatile table or not. This option pertains to global temporary and volatile tables only.
|699||03 Jul 2014 @ 12:22 PDT||Database||Reply||Create a table with a date column that has a default lenght (8)||It is always easier if you share some example code...
Some clarification - a date data type is stored as 4 byte. Always.
What you can specify is the format how the date is shown, but this does no... |
|698||30 Jun 2014 @ 12:23 PDT||Database||Reply||Skewfactor||Values < 1 are OK. You might not getting better even if you use a UPI - depending on your number of rows and number of vprocs.
But as so often there are no fix numbers to say what is acce... |
|697||30 Jun 2014 @ 12:16 PDT||General||Reply||In BTEQ if we want to go forward we use condititional logic (if ..then GO TO .Label name).By using BTEQ can we go backward?||Hi,
no, you can't go backwards with an .goto statement.
|696||26 Jun 2014 @ 02:51 PDT||General||Reply||If hash collision occurs,how can we rectify this issue.||Hi,
can you provide some more details of your problem? What is the issue with the hash collision?
|695||24 Jun 2014 @ 11:48 PDT||Database||Reply||Types of Tablekind||your can run a
select tablekind from dbc.tables group by tablekind order by tablekind;
so see which are currently existing in your system.
By the way tablekind is very much misslea... |
|694||05 Jun 2014 @ 02:26 PDT||Database||Reply||How to calculate a character occurance in a string in teradata||which version are you on?
|693||15 May 2014 @ 11:24 PDT||General||Reply||Number of bytes-BIGINT||There is no doubt - 8 bytes
from the manuals - SQL Data Types and Literals
"BIGINT values are stored as eight bytes with the least significant byte first."
|692||14 May 2014 @ 01:01 PDT||Database||Reply||How to calulate Skew on Join Index||The join index is created by an SQL therfore using this SQL as a derived table should give you the right info.
SELECT HASHAMP(HASHBUCKET(HA... |
|691||13 May 2014 @ 04:46 PDT||Database||Reply|| incremental planning and execution (IPE)||yes, I used "only" 1 Mio rows on the PPI table.
But the SSI queries also contained a UPI access so should be pretty fast. I was wondering where to draw the line and was therefor asking f... |
|690||13 May 2014 @ 12:19 PDT||Database||Topic|| incremental planning and execution (IPE)||Hi all,
I am exploring the new IPE feature on 14.10. Very nice!
But sometimes the explain is showing
"This request is eligible for incremental planning and execution (IPE)
|689||06 May 2014 @ 12:52 PDT||Database||Reply||Identifying Temporal Tables||In 14.10 the dbc documentation states that tables views should have the column
Further down you find the following description:
The TemoralPrope... |
|688||29 Apr 2014 @ 02:35 PDT||Tools||Reply||Can we use where clause in TPT Export selector||try to replace all ' with '' within the select. Something like
|687||28 Apr 2014 @ 12:20 PDT||Tools||Reply||Loading carriage returns with TPT Load Operator||sad, sad...
|686||26 Apr 2014 @ 12:50 PDT||Tools||Reply||Loading carriage returns with TPT Load Operator||Will it make in 15.0?
It creates so much overhead if you have to deal with it in preprosessing. These social network sources are full of this as it all about free text fields...
|685||16 Apr 2014 @ 07:05 PDT||Third Party Software||Reply||Bi tool cannot read from different databases in teradata?||Hm, not so easy to answer. I am not sure that I understand how the dead lock occurs.
Questions: is the read lock nessesary for you? Would lock row for access be OK?
I would strongly avoid the cre... |
|684||07 Feb 2014 @ 11:38 PST||Analytics||Reply||teradataR package and R 3.0.0||Just verified the package at (see message from nonsleeper above)
git clone https://github.com/Teradata/teradataR/
is just working fine.
What kind of message to you get?
R version 3.0.2 (2013-... |
|683||07 Feb 2014 @ 10:50 PST||Teradata Applications||Reply||TPT export and error code 2595||P.S. the error does not occur at TPT startup. There is already some GB of data retrieved...