#DateForumTypeThreadPost
1330 Oct 2015 @ 02:23 PDTAsterTopicAster Express Installation IssueHi,   We are getting errors while installing Aster Express on Vsphere environment. We are not able to activate the cluster and the errors encountered are attached.
1230 Jul 2015 @ 01:54 PDTAsterTopichow do you find the create time stampHow do we check the create time stamp for a table / view in Teradata Aster? I could not obtain it from the nc_system views!   Like in Teradata : select createtimestamp from dbc.tables where...
1130 Oct 2014 @ 06:42 PDTAsterTopicHow to find out the create time stamp of an Aster table?
1028 Oct 2014 @ 04:53 PDTAsterReplyCanceling queries without ncliYou an use Aster Management Console to cancel your queries.   Cancelling queries Method 1: Hit abort button in your Tool. Method 2: ncli Method 3: Login to AMC > Processes. Click Cance...
928 Oct 2014 @ 04:47 PDTAsterReplyView Table Structure in ACT\d schemaname.tablename shows  columnname column type modifiers for columns table type (fact/dimention ) distribution key storage type ( row / column)  permanent   What you ...
828 Oct 2014 @ 04:31 PDTAsterReplylimit rows Yes Sir, Every time limit will pick up randowm rows. But if you run teh same select with limit there are chances you might get a specific result set. well, the answer in single word is YES, random...
728 Oct 2014 @ 04:16 PDTAsterReplyRenaming a Table in Aster Amateurs like me get a failure error when the following syntax is submitted.   FAILS alter table ABC.rename_test rename to ABC.rename_test_2;  --Fails   But wh...
628 Oct 2014 @ 04:09 PDTAsterTopicRenaming a Table in AsterHow to rename a table in Aster?   if you are in a schema = ABC, but the search path schema does not have ABC, then it might be challenging to rename the table in schema ABC.
508 Oct 2014 @ 10:24 PDTAsterReplyHow to add partition to a pre created table?Figured it out.   YOU CANNOT ALTER A TABLE AND ADD PARTITION   In Aster, you can only add partitions or remove partitions to a logically partitioned table. ( unlike in teradata where...
408 Oct 2014 @ 10:23 PDTAsterReplyregarding documnentaion for aster technologyhttps://www.google.com/search?q=Teradata+Aster+Big+Analytics+Appliance+3H+SQL+and+Function+Reference&oq=Teradata+Aster+Big+Analytics+Appliance+3H+SQL+and+Function+Reference&aqs=chrome..69i5...
308 Oct 2014 @ 10:21 PDTAsterReplystored proceduresNo, Unfortunately you cannot create a stored procedure in Aster .
230 Sep 2014 @ 04:25 PDTAsterReplyregarding documnentaion for aster technologyDo they have Aster Documentation like that for Teradata?
129 Sep 2014 @ 04:22 PDTAsterTopicHow to add partition to a pre created table?I know in Aster, we can add partitions to logically partitioned table. We can also remove partitions from a logically partition table.   My question is if you create a table and forget to pa...