|46783||18 Dec 2014 @ 01:29 PST||escueta||General||Topic||COPY Table question||If I use the COPY Table to copy a table from one database to another database (same server) and the table already exist, will it drop and recreate the table?
|46782||18 Dec 2014 @ 01:16 PST||john9||Database||Topic||View TPT Log||Hi ALL -
I have executed a TPT script with export operator and able to generate the output data file successfully......and i also see a log file in the path
|46781||18 Dec 2014 @ 10:39 PST||Fred||Database||Reply||Join Index and Value Ordering||Rows are still distributed to an AMP based on the high order portion of the RowHash, but within an AMP the ordering value is substituted in place of the RowHash (in the MI/... |
|46780||18 Dec 2014 @ 09:44 PST||Fred||Database||Reply||System Views DBC.COLUMNSTATS & DBC.MULTICOLUMNSTATS not existig in TD 14||With the TD14 views, rows will be only returned when stats are present, so there is no need for the NOT NULL filter in the above queries.
(Alternatively, if you were interested in findin... |
|46779||18 Dec 2014 @ 09:32 PST||tomnolan||Database||Reply||CREATE TABLE AS STATEMENT ERROR||It's probably a Teradata Database bug. If you're a customer, you can open an incident with Teradata Customer Service to report the problem.
|46778||18 Dec 2014 @ 08:14 PST||Raja_KT||General||Reply||Running Teradata Script in Unix||Example of bteq script from the documentation:
|46777||18 Dec 2014 @ 07:59 PST||achikan01||Database||Reply||CREATE TABLE AS STATEMENT ERROR||There is no concerns.
My question is why the second & third column showing as reserved word?
|46776||18 Dec 2014 @ 06:50 PST||vinaynaran||Database||Reply||Dynamic Date Range in where clause||Hi Rohan,
It working Perfect. Thank you very much for your time.
|46775||18 Dec 2014 @ 06:12 PST||v_gabrielli||Database||Topic||create a composite Collect stats command||SELECT databasename,tablename,indexnumber,columnName, columnPosition,
'COLLECT STATISTICS ON ' || TRIM(databasename) ||'.'|| TRIM(tablename) ||' ... |
|46774||18 Dec 2014 @ 04:58 PST||Rohan_Sawant||Database||Reply||Dynamic Date Range in where clause||
As per the query you pasted here the data will be pulled (I am quite sure on this. I suppose you ran both queries on different days).
As per the time perspective,var... |
|46773||18 Dec 2014 @ 04:19 PST||vinaynaran||Database||Reply||Dynamic Date Range in where clause||Hi RS,
Thanks for Reply. This is what I am looking for but is not working. please see below qry. its take to much time and does not pull any data.
|46772||18 Dec 2014 @ 03:18 PST||Vinay151||General||Topic||Running Teradata Script in Unix||Hi,
I'm new to Teradata. We can run the Netezza SQL in Unix by using "nzsql" command.
nzsql -host hostname -u username -pw password -db Databasename -c "... |
|46771||18 Dec 2014 @ 02:49 PST||Rohan_Sawant||General||Reply||Help in writing SQL||Hi Rajesh,
I have created the above scenario and made a recursive query to achieve the above.
CREATE MULTISET VOLATILE TABLE VT_ZONE_CITIES
, CIT... |
|46770||18 Dec 2014 @ 01:51 PST||kuruvarajeshkumar||General||Reply||Help in writing SQL||Thank You...will try and get back to you
|46769||18 Dec 2014 @ 12:34 PST||Rohan_Sawant||General||Reply||Dynamic Date Range in where clause||
I have already posted the same reply in your previous post:
The above solution provided by Dieter is for TD 14 release I suppose.
In case you ne... |
|46768||18 Dec 2014 @ 12:19 PST||ulrich||Database||Reply||CREATE TABLE AS STATEMENT ERROR||OK, there is this difference of double quoted names - but what is your concern?
"colname" is still refering to the colname...
So there is no difference in the actual table definition...
|46767||17 Dec 2014 @ 09:53 PST||Rohan_Sawant||Tools||Reply||TERADATA PROFILER QUERIES||Hi Raja_KT,
I could see the SQL's in SQL tab but I just want the standard queries used in Profiler. I wanted to understand the standard ways in which a Profiler does profiling of data. If some... |
|46766||17 Dec 2014 @ 07:31 PST||Raja_KT||Tools||Reply||TERADATA PROFILER QUERIES||I remember vaguely how I resolved once the issue, when I tweaked a query, 2 years back. I do not know if TD Profiler has changed , the look and feel since then. I think in INPUT, OUTPUT, RESULTS...... |
|46765||17 Dec 2014 @ 06:39 PST||belladikto||UDA||Topic||BACKUP TABLE||friends, the following error when trying to support me appears tables:
12/17/2014 22:28:26 ARCHIVING DATABASE "ARG_SUPER_STG"
12/17/2014 22:28:27 *** Warning ARC1016:T... |
|46764||17 Dec 2014 @ 03:20 PST||achikan01||Database||Topic||CREATE TABLE AS STATEMENT ERROR||Apparent anomaly in the functioning of the CREATE TABLE AS statement. In the following SQL, the B_TEST table DDL gets created with double-quotes around the CHECK col in 2 cases:
CREATE MULTISE... |
|46763||17 Dec 2014 @ 01:59 PST||dnoeth||Database||Reply||SQL to TERADATA Migration||You do the same you should do in MS SQL Server instead of the proprietary  syntax, use double quotes:
You CONVERT example is not valid syntax in MS. But col1 seems t... |
|46762||17 Dec 2014 @ 01:41 PST||dnoeth||General||Reply||Dynamic Date Range in where clause||Hi Vinay,
why do you post the same question twice?
What's your TD release?
WHERE calendar_date BETWEEN NEXT_DAY(CURRENT_DATE-8, 'mon') AND CURRENT_DATE-1
WHERE calendar_... |
|46761||17 Dec 2014 @ 12:19 PST||Glass||Viewpoint||Reply||List of workloads with users & profile||Nomi,
Wdname is found on pdcrdata.dbqlogtbl_hst so you can associate it with users there for users that have submitted queries.
Also they may be able to run in multiple workloads but h... |
|46760||17 Dec 2014 @ 09:15 PST||gryback||UDA||Reply||Download DataMover 15.00.||Data Mover 15.00 is available on the Teradata Software Server "patch" server. However as this is a licensed product, you need to formally submit an order for it through your Teradata... |
|46759||17 Dec 2014 @ 09:11 PST||vishaman||Aster||Reply||load_from_hcatalog when templeton is not on namenode|| I tried running the below query with our new Teradata version 14.10, SQL-H capability to query a Hortonworks Hadoop environment enabled and got an error.