All forum activity

#DateUserForumTypeThreadPost
4678318 Dec 2014 @ 01:29 PSTescuetaGeneralTopicCOPY Table questionIf 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?   Thanks Chris
4678218 Dec 2014 @ 01:16 PSTjohn9DatabaseTopicView TPT LogHi 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 /opt/teradata/client/14.10/tbuild/logs...
4678118 Dec 2014 @ 10:39 PSTFredDatabaseReplyJoin Index and Value OrderingRows 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/...
4678018 Dec 2014 @ 09:44 PSTFredDatabaseReplySystem Views DBC.COLUMNSTATS & DBC.MULTICOLUMNSTATS not existig in TD 14With 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...
4677918 Dec 2014 @ 09:32 PSTtomnolanDatabaseReplyCREATE TABLE AS STATEMENT ERRORIt's probably a Teradata Database bug. If you're a customer, you can open an incident with Teradata Customer Service to report the problem.
4677818 Dec 2014 @ 08:14 PSTRaja_KTGeneralReplyRunning Teradata Script in UnixExample of bteq script from the documentation: #!/bin/sh ######################################### bteq <<EOI export DATADIR=/datasvc/data .LOGON mydbs/myid,mypw; .EXP...
4677718 Dec 2014 @ 07:59 PSTachikan01DatabaseReplyCREATE TABLE AS STATEMENT ERRORThere is no concerns. My question is why  the second & third column showing as reserved word?
4677618 Dec 2014 @ 06:50 PSTvinaynaranDatabaseReplyDynamic Date Range in where clauseHi Rohan,   It working Perfect. Thank you very much for your time. Thanks Vinay  
4677518 Dec 2014 @ 06:12 PSTv_gabrielliDatabaseTopiccreate a composite Collect stats commandSELECT  databasename,tablename,indexnumber,columnName, columnPosition, 'COLLECT STATISTICS ON ' || TRIM(databasename)   ||'.'||   TRIM(tablename) ||' ...
4677418 Dec 2014 @ 04:58 PSTRohan_SawantDatabaseReplyDynamic Date Range in where clause Hi Vinay,   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...
4677318 Dec 2014 @ 04:19 PSTvinaynaranDatabaseReplyDynamic Date Range in where clauseHi 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.   select calendar_date, sum(Sca...
4677218 Dec 2014 @ 03:18 PSTVinay151GeneralTopicRunning Teradata Script in UnixHi,    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 "...
4677118 Dec 2014 @ 02:49 PSTRohan_SawantGeneralReplyHelp in writing SQLHi Rajesh, I have created the above scenario and made a recursive query to achieve the above.   CREATE MULTISET VOLATILE TABLE VT_ZONE_CITIES ( "ZONE" VARCHAR(10) , CIT...
4677018 Dec 2014 @ 01:51 PSTkuruvarajeshkumarGeneralReplyHelp in writing SQLThank You...will try and get back to you
4676918 Dec 2014 @ 12:34 PSTRohan_SawantGeneralReplyDynamic Date Range in where clause Hi Vinaynaran,   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...
4676818 Dec 2014 @ 12:19 PSTulrichDatabaseReplyCREATE TABLE AS STATEMENT ERROROK, 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...
4676717 Dec 2014 @ 09:53 PSTRohan_SawantToolsReplyTERADATA PROFILER QUERIESHi 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...
4676617 Dec 2014 @ 07:31 PSTRaja_KTToolsReplyTERADATA PROFILER QUERIESI 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......
4676517 Dec 2014 @ 06:39 PSTbelladiktoUDATopicBACKUP TABLEfriends, 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...
4676417 Dec 2014 @ 03:20 PSTachikan01DatabaseTopicCREATE TABLE AS STATEMENT ERRORApparent 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...
4676317 Dec 2014 @ 01:59 PSTdnoethDatabaseReplySQL to TERADATA MigrationYou do the same you should do in MS SQL Server instead of the proprietary [] syntax, use double quotes: "CUSTOMER ID" You CONVERT example is not valid syntax in MS. But col1 seems t...
4676217 Dec 2014 @ 01:41 PSTdnoethGeneralReplyDynamic Date Range in where clauseHi 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_...
4676117 Dec 2014 @ 12:19 PSTGlassViewpointReplyList of workloads with users & profileNomi, 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...
4676017 Dec 2014 @ 09:15 PSTgrybackUDAReplyDownload 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...
4675917 Dec 2014 @ 09:11 PSTvishamanAsterReplyload_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. SELECT  &nbs...

Pages