Tags for view
How to check View size in Teradata
In Teradata DB, generally expectation would be to get the data size for a table, but for my task I need to identify size of a View. This view contains joins from 3 different tables and all I could identify is the count of the View - 757747 records now. Reason behind this is to determine data file size for export and use it in another DB.
view table-size
Using TDCH Export to move data from Hive view or query into Teradata
I have a Hive table that is too big for my Teradata database, but if I can exclude some of the columns, it should be OK.  Since I don't want to have a duplicate copy of the table with fewer columns on my hadoop server I have two choices for import:    1) use a view to filter out the columns or    2) use a query to filter out the columns.
hadoop view tdch
View on View problem
We are using Views rather much. Data flows from tables trough several Views before they are used. To simplify: I have the following construct (the actual table and views are much more complicated, and there are a lot of data in the table):
view SLOW RUNNING QUERY
Views - Internal execution steps
Hi,   I have a quick question regarding processing of views.  
view explain transpose eavt spool
LastAccess Time stamp not getting updated for table
I have come across a strange situation. I have a view which points to a Global temporary table. There is a daily process that runs a macro to insert data into the view and then use it for select query Joins.  
dbc.tables lastaccesstimestamp view
Performance and view-on-view approach
Hi Guys, thanks for reading the post. I did do a search for "view on view" and there was no result.
sql views view performance
create a view using WITH
The Teradata 14.0 DDL manual shows that you can do the following, using a common table create view rdptest as ( with test1 (clnt_cd,clnt_id) as (select clnt_cd,clnt_id from dbatest_core_tb.clnt) select clnt_cd,clnt_id from test1 ) ;  
cte view
Add title to view column
Hi Try to find some info about how to add info into a Title attribute for a View Column... No luck... I can stuff Comment into all objects, and Titles into table columns, but view columns... no  ! Is it against some nature of the TD database ? Any hints ?   Regards /T
title view column
View's base table timestamp
Hi, I am finding out set of view's base table's last access timestamp. Right now I do 1. show view on the view name 2. Get the table name from the result 3. And find the table's last access time stamp from dbc.tables  
view base table
Creating a view from a CTE query
Hello I'm trying to create a view from WITH ... SELECT query.  The query itself works fine but once I try to create a view from it, I get a 3707 error.   I'm running off TD 14.10.  Any thoughts? Thanks, Richard
cte view

Pages