58167 | 02 Jul 2016 @ 01:26 PDT | kchinnad | Teradata Studio | Reply | Terdata Studio - Connection to Hive - Database is not listing | Hi 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... |
58166 | 01 Jul 2016 @ 03:51 PDT | ToddAWalter | General | Reply | Teradata to AWS(Redshift) | Or better yet just use Teradata on AWS to run your work there!
|
58165 | 01 Jul 2016 @ 01:17 PDT | dhg | General | Reply | Teradata 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 ... |
58164 | 01 Jul 2016 @ 01:17 PDT | Fred | Training | Reply | Script with the variable CURR_DATE | CURR_DATE appears to be a column in your Reporting_DB.V_REPORT_DATE view.
|
58163 | 01 Jul 2016 @ 01:12 PDT | Fred | Database | Reply | Teradata 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).
|
58162 | 01 Jul 2016 @ 10:38 PDT | teja420 | Database | Reply | How to find Table name, column name, column datatype and Number of row in table | Thank you very much Dnoeth :)
|
58161 | 01 Jul 2016 @ 09:16 PDT | fgrimmer | Teradata Studio | Reply | Terdata 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 ... |
58160 | 01 Jul 2016 @ 09:03 PDT | fgrimmer | Teradata Studio | Reply | Studio Express severe keyboard lag | Steven, We will continue to look into this issue.
|
58159 | 01 Jul 2016 @ 08:33 PDT | ericm | Training | Topic | Script with the variable CURR_DATE | I 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... |
58158 | 01 Jul 2016 @ 12:07 PDT | piyush.lohana | Database | Reply | Teradata 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?
|
58157 | 30 Jun 2016 @ 11:20 PDT | dnoeth | Database | Reply | Error when trying to create a function | This 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... |
58156 | 30 Jun 2016 @ 11:11 PDT | dnoeth | Database | Reply | How to find Table name, column name, column datatype and Number of row in table | dbc.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... |
58155 | 30 Jun 2016 @ 11:09 PDT | dnoeth | General | Reply | Query issue | QUALIFY 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... |
58154 | 30 Jun 2016 @ 09:04 PDT | teja420 | Database | Topic | How to find Table name, column name, column datatype and Number of row in table | Hi 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,
|
58153 | 30 Jun 2016 @ 04:07 PDT | Fred | Database | Reply | Revoke User | You 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... |
58152 | 30 Jun 2016 @ 03:51 PDT | Fred | Connectivity | Reply | ODBC 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 ... |
58151 | 30 Jun 2016 @ 03:40 PDT | BI_guy | General | Reply | Query issue | HELP WITH THE QUERY -TERADATA :(((
|
58150 | 30 Jun 2016 @ 03:38 PDT | BI_guy | General | Reply | Query issue | Need some help ???
|
58149 | 30 Jun 2016 @ 03:38 PDT | BI_guy | General | Topic | Query issue | Query -
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... |
58148 | 30 Jun 2016 @ 03:37 PDT | Fred | Tools | Reply | 2555: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... |
58147 | 30 Jun 2016 @ 03:26 PDT | teradatauser2 | Connectivity | Topic | Error 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... |
58146 | 30 Jun 2016 @ 01:00 PDT | jpw111082 | Database | Topic | Error when trying to create a function | Hi, 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 ... |
58145 | 30 Jun 2016 @ 10:13 PDT | hyma | Database | Reply | Create NUPI and USI having the same Column | It's a question. The table has no PPI.
|
58144 | 30 Jun 2016 @ 09:12 PDT | hvganipineni | Tools | Reply | TPT deadlock Issue. | Hello Suhail, Just curious did you guys upgrade? And did it fix your problem?
|
58143 | 30 Jun 2016 @ 09:08 PDT | hvganipineni | Tools | Reply | 2555:TABLE DOES NOT BELONG TO THE MLOAD JOB. | Could you please share your script?
|