All Forums Cloud Computing
kss 1 post Joined 01/14
22 Aug 2015
test data/tables in Teradata Express 13.0 for VMware (4 GB)??

I have Teradata Express 13.0 for VMware (4 GB) up and running. But I could not find any test data/tables in there. Can someone direct me how to find test data where I can query? Do I have to download and run 40GB or 1TB in order to get the test data?
Thank you. 

rupert160 131 posts Joined 09/10
03 Sep 2015

in TD15 I have several DB's under "Samples", there's "retail", "financial" etc. Not sure about 13
run this and you'll get some datasets to play with:

select top 50 
databasename
, tablename
, CurrentPerm
from dbc.tablesize
order by CurrentPerm desc
;

 

ganeshbabu 2 posts Joined 02/13
25 Jan 2016

Hi,
I recently installed TDExpress15.10.0.7_Sles11_40GB_vp. However i am unable to see "Samples" DB when i query DBC.Tables. Can any one help?
 
Thanks.

Fred 1096 posts Joined 08/04
25 Jan 2016

The tables are not in the Samples DB itself, they are in databases below Samples in the hierarchy.
 
SELECT DatabaseName, TableName FROM DBC.TablesV
WHERE DatabaseName in (SELECT Child FROM DBC.ChildrenV WHERE Parent = 'Samples');

You must sign in to leave a comment.