All forum activity

#DateUserForumTypeThreadPost
5816702 Jul 2016 @ 01:26 PDTkchinnadTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listingHi Fgrimmer,  Thanks. My intention is to run only SQL queries against Hive tables that's all. when i create the Hortonworks Connection with just JDBC alone ( without select...
5816601 Jul 2016 @ 03:51 PDTToddAWalterGeneralReplyTeradata to AWS(Redshift)Or better yet just use Teradata on AWS to run your work there!
5816501 Jul 2016 @ 01:17 PDTdhgGeneralReplyTeradata to AWS(Redshift)Redshift will want a delimited flat files per table.  The simipliest way is to use TPT export/fastexport to gz compressed delimited flat files to on prem storage.  If you look around you ...
5816401 Jul 2016 @ 01:17 PDTFredTrainingReplyScript with the variable CURR_DATECURR_DATE appears to be a column in your Reporting_DB.V_REPORT_DATE view.
5816301 Jul 2016 @ 01:12 PDTFredDatabaseReplyTeradata Table Naming No, existing objects are not affected. The new Name Validation rule applies when you CREATE new objects (or for the new name specified on a RENAME).
5816201 Jul 2016 @ 10:38 PDTteja420DatabaseReplyHow to find Table name, column name, column datatype and Number of row in tableThank you very much Dnoeth :)
5816101 Jul 2016 @ 09:16 PDTfgrimmerTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listing@kchinad, I am confused as to why you need to enter TDCH connection information? When you create the Hortonworks Connection with just JDBC and press Test Connection, is it successful? If not, what ...
5816001 Jul 2016 @ 09:03 PDTfgrimmerTeradata StudioReplyStudio Express severe keyboard lagSteven, We will continue to look into this issue.
5815901 Jul 2016 @ 08:33 PDTericmTrainingTopicScript with the variable CURR_DATEI am new to TeraData and Data Warehouses. I have a stored procedure that utilizes the following code: SELECT CALENDAR_DATE AS Reporting_Date, CAST('LD' AS VARCHAR(10)) AS Repor...
5815801 Jul 2016 @ 12:07 PDTpiyush.lohanaDatabaseReplyTeradata Table Naming What happens if I have some tables in the database which have names more than, lets say 30 chars long, and NameValidationRule now is set to 1? Do I have to first rename those tables?
5815730 Jun 2016 @ 11:20 PDTdnoethDatabaseReplyError when trying to create a functionThis is Oracle source code, of course it's not working as-is on Teradata. See http://forums.teradata.com/forum/general/convert-13-digit-epoch-time-to-date#comment-148179 for an example to cast...
5815630 Jun 2016 @ 11:11 PDTdnoethDatabaseReplyHow to find Table name, column name, column datatype and Number of row in tabledbc.TablesV -> table metadata dbc.columnsV -> column metadata If an approximate count is ok you might simply query dbc.StatsV, otherwise you need Dynamic SQL in a Stored Procedure to do the...
5815530 Jun 2016 @ 11:09 PDTdnoethGeneralReplyQuery issueQUALIFY must be moved out of the WHERE: -- move the closing paren WHERE (snap_dt = ADD_MONTHS(CURRENT_DATE,0)-EXTRACT(DAY FROM ADD_MONTHS(CURRENT_DATE,0)) and PMORTG.BDE_TFCLSTEP_P...
5815430 Jun 2016 @ 09:04 PDTteja420DatabaseTopicHow to find Table name, column name, column datatype and Number of row in tableHi Team, Can any one please help me with the query to pull all Table name, column name, column datatype and Number of row in table in teradata. Please respond. Thanks in advance Regards,
5815330 Jun 2016 @ 04:07 PDTFredDatabaseReplyRevoke UserYou typically don't have LogonRules for every user; there are generic / "wild card" rules as well. The search order is: Session UserName and LogicalHostID both match a&nb...
5815230 Jun 2016 @ 03:51 PDTFredConnectivityReplyODBC error (64bit)Teradata Studio doesn't use ODBC.   If you need ODBC for some other application, you probably need to clean up a previous failed install. Within the TTU distribution there is ...
5815130 Jun 2016 @ 03:40 PDTBI_guyGeneralReplyQuery issueHELP WITH THE QUERY  -TERADATA  :(((
5815030 Jun 2016 @ 03:38 PDTBI_guyGeneralReplyQuery issueNeed some help ???
5814930 Jun 2016 @ 03:38 PDTBI_guyGeneralTopicQuery issueQuery - SELECT PMORTG.BDE_TFCLSTEP_PT.LOAN_NUM, PMORTG.BDE_TFCLSTEP_PT.FCLSR_SETUP_DT, PMORTG.BDE_TFCLSTEP_PT.FCLSR_STEP_SEQ_NUM, PMORTG.BDE_TFCLSTEP_PT.F...
5814830 Jun 2016 @ 03:37 PDTFredToolsReply2555:TABLE DOES NOT BELONG TO THE MLOAD JOB.The MLOAD itself must create the log, work, and error tables when first started, and any restart must use the tables created by the initial run. You cannot create or drop these tables ma...
5814730 Jun 2016 @ 03:26 PDTteradatauser2ConnectivityTopicError while setting up proxy user using BO Hi,   I am working to set up a proxy user to connect from BO to teradata. I am able to test this using sql assistant. Basically, i am executing two commands :    1...
5814630 Jun 2016 @ 01:00 PDTjpw111082DatabaseTopicError when trying to create a functionHi, I am trying to create my first function in Teradata SQL Assistant using a script I found on the internet.  the purpose of the function is to convert a timestamp to a unix timestamp and is ...
5814530 Jun 2016 @ 10:13 PDThymaDatabaseReplyCreate NUPI and USI having the same ColumnIt's a question. The table has no PPI.
5814430 Jun 2016 @ 09:12 PDThvganipineniToolsReplyTPT deadlock Issue.Hello Suhail, Just curious did you guys upgrade? And did it fix your problem?
5814330 Jun 2016 @ 09:08 PDThvganipineniToolsReply2555:TABLE DOES NOT BELONG TO THE MLOAD JOB.Could you please share your script?  

Pages