All Forums

For topics related to the Teradata Aster platform, including Aster Express for VMware Player.

You must login to post to the forums.
Stored Procedures work-around Topic by u2fox 06 Nov 2014 aster, stored procedure, sp

Hi,
I was wondering if there are work-arounds for creating stored procedures in Teradata Aster without using SQL-MapReduce.
Thanks
Federico

1599 views
1 reply, 4 years ago
How an Aster user can see all the tables within a schema (not public schema)? Topic by dm186036 11 Dec 2014 grant usage on schema, aster 6.00, schema, privileges, roles

Hello guys,
 
I am trying to find out a solution/an answer for my problem for some days and my conclusion (till now) is this one: it's possible to grant access for a schema to a role, but nor for its (schema's) content. Please correct me if I am wrong. 
 
Here is my problem:
 

2010 views
1 reply, 4 years ago
Columnar table and NULL values - space savings or no? Topic by mcooper@intellicog.com 18 Feb 2015

Just curious: If I had a columnar table, and one of the columns was usually NULL, would there be any space savings over a row-oriented table with the same set of columns and data?
(Note: I realize that it would be better to simply not have that column.  I'm asking a hypthetical question and trying to make its terms clearer.)

948 views
0 replies
Where can I get theAster ncluster odbc driver Topic by amitdutta 21 Jan 2015 aster, odbc, r

Where can I get theAster ncluster odbc driver for mac os. I need the driver for RODBC connectivity. 

1259 views
1 reply, 4 years ago
aster developer express Topic by adhamsabry51 13 Oct 2014

Dear all
thats my first posting in the forum 
am preparing my final project for master and am working on aster express
the fact is thats my first time ever working on it and i am trying to find aster developer express to download but am not able to find any download link for it directly and i dont know how to create map reduce project on eclipse without it

1728 views
3 replies, 4 years ago
"No interface found" for eth0 and eth1. VMWare Fusion on MAC OS X Yosemite Topic by nbui 24 Jan 2015 mac, apple, os x, yosemite, vmware, fusion, aster, aster express

Hello,
I'm trying to run Aster Express on my Macbook. I have VMWare Fusion. I set up the network using these following instructions (http://donaldaly.blogspot.com/2012/12/running-teradata-aster-express-on.html).

However, my NIC's are no good. What can I do?

1560 views
0 replies
Aster Documentation Topic by amitdutta 14 Jan 2015 aster 6.00, documentation

Hi All
Can someone please point me tothe Aster Documentation. All I couldfind is
http://www.info.teradata.com/AsterData/eBrowseBy.cfm?Page=AsterDatabase
I want some document which explains analytical function etc.
 
Thanks,
Amit
 

1084 views
0 replies
Sample Data For learning TPN Topic by amitdutta 14 Jan 2015 aster 6.00, learning examples

Hi All,
I am new to Aster. I have Aster Teradata Professional Network Plus Membership. I was going thru a video but could not find a location for the sample data they were discussing. Like the bank data etc... Can some one please provide the link for the sample data etc.
Thanks,
Amit
 
 

937 views
0 replies
Batch Processing Logistic Regression Models Topic by dylanzwick 25 Nov 2014 logistic regression

I'm new to Aster, so please forgive me if this is a dumb question.
I have a dataset with five columns: A, B, C, D, E

1494 views
1 reply, 4 years ago
load_from_hcatalog when templeton is not on namenode Topic by rupert160 05 May 2014

Hello guys,
I have a HDP instance that has templeton on a secondary node and so instead of my connector being:

1946 views
1 reply, 4 years ago
Windows 8.1 - VMWare Player 6 - Aster Express v. 15 - Unable to use Aster Management Console Topic by jason.reilly@outlook.com 11 Nov 2014 aster express, Newbie

Hello Everyone!
For reference:
- My host system is Windows 8.1
- I'm using VMWare Player 6
- I'm trying to run Aster Express v15

1711 views
1 reply, 4 years ago
RSCRIPT: Issue with groups of split data by PARTITION BY clause Topic by esaurg 21 Nov 2014 stream, partition by, rscript

Hi, this is my first post
I'm a beginner in Aster (nCluster v.6.0.1.00) and I am interested in using R scripts.

1033 views
0 replies
table_from_afs Topic by omri.shiv 07 Nov 2014

Hello,
I'm trying to get some clarification on the table_from_afs function, specifically the INPUT_FORMAT and SERDE. I installed the set of JARs for Apache's POI for Microsoft Office parsing. I'm trying to parse a Word document using the following code:

 SELECT * FROM table_from_afs(

 ON mr_driver

 PATH('/home/db_superuser/document.doc')

986 views
0 replies
Aster File System in 6.X Topic by kedhars 28 Oct 2014 Aster file system, File loading

Does anyone know, how to load the file directly into the Aster File System 6.0(like we do in HDFS using put command). Currently we are using java streams which reads the file and write it in the Aster tables.
Please advice.

1435 views
1 reply, 4 years ago
881 views
0 replies
Aster SQL-GR functions Topic by SamiShah 30 Oct 2014 aster, SQL-GR

Can any one please tell me where can i find built-in SQl-GR functions for aster 6.0? 

1430 views
0 replies
Canceling queries without ncli Topic by jonathanswensonsc 13 Aug 2013

Is it possible to cancel a query/process using via running sql commands. I want to achieve the same result as running `ncli query cancelprocess <processid>` but using JDBC rather than having to use ncli. 
Any suggestions?

2253 views
2 replies, 4 years ago
View Table Structure in ACT Topic by Parkman328 13 Feb 2014

Is there a way to view table structure in Aster ACT.  Such as show table tablename;
Thanks,
John

3098 views
3 replies, 4 years ago
limit rows Topic by wt186005 21 Oct 2014 random sample

When one is using this function in a query in Aster, is a random set of rows returned (assuming there is no order by specification).
 

2015 views
1 reply, 4 years ago
Renaming a Table in Aster Topic by kseshasaisrivatsav 28 Oct 2014 rename table, alter table

How 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.

1886 views
1 reply, 4 years ago
Aster nPath Functionality Example error Topic by toadrw 24 Oct 2013 npath

Hello:
I'm trying to do the Aster nPath Functionality Volume II example from this link:
http://www.asterdata.com/download_aster_express/npath-functionality-vol2.php
And I'm getting the following error:

2242 views
2 replies, 4 years ago
Open second instance of the VMware Player Topic by snetuschil 16 Oct 2014 VMWare Player

Hello,
 
after recieving much appreciated help regarding the Aster Express startup guide, I already have a follow-up question. The guide states:
14 To get the Worker virtual machine up and running, open another instance of the VMware Player

853 views
0 replies
Aster Express Tutorial Topic by snetuschil 15 Oct 2014 aster express tutorial

Hi,
 
there used to be an online tutorial for Aster Express under this adress: http://staging.asterdata.com/download_aster_express/tutorial.php
 

1727 views
2 replies, 5 years ago
How to add partition to a pre created table? Topic by kseshasaisrivatsav 29 Sep 2014 aster, logical partitioning

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 partition it. How will you add partitioning?
 
 
Example:

Case (i) Adding Partitions 

--1. original table DDL

create table public.partition_test_1 

3573 views
1 reply, 5 years ago
regarding documnentaion for aster technology Topic by venkat.nandipati 16 Sep 2014

Hi
can i get a link for downloading a pdf about aster basics like how the architecture works . why do we require aster ? , syntax etc
I have googled for long but in vain .
Kindly help me with it .
 

986 views
4 replies, 5 years ago

Pages