All Forums

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

You must login to post to the forums.
syntax error load_from_hcatalog Topic by luca.natali 23 Sep 2015 aster, hadoop, hortonworks, hdp, connectivity, load_from_hcatalog, load

Hi,
I have TD Studio 15.10, TD DB 15.0, HDP 2.0 and Aster 6.0. They are all connected well in TD Studio and I can see the tables.
I'm doing some tests on Aster based on a HDP table but when I execute the query:
 
SELECT * FROM load_from_hcatalog
(USING server('192.168.100.131')
port('9083')
username('root')
dbname('db')

877 views
1 reply, 3 years ago
Aster express 6.1 Topic by bibby hsu 12 Sep 2015

Hi all,
Aster express 6.1 what date available?

Many thanks. 

417 views
0 replies
installation of GeoLiteCity Topic by dsc 15 Jul 2015

Hi,
i try to install GeoLiteCity out from the Analytics package by using:
act -h 10.211.56.101 -U db_superuser -w db_superuser -c '\install geolite128_database/GeoLiteCityv6.dat; '
the command fails with An error has occurred during command execution: SyncConnection.cpp:144.
any idea?

1200 views
3 replies, 4 years ago
how do you find the create time stamp Topic by kseshasaisrivatsav 30 Jul 2015 createtimestamp

How 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 tablename ='xasdas'

691 views
0 replies
ncluster_loader or Studio data import for Mac Topic by duncanirving 16 Jul 2015 aster, mac, ncluster, studio

Is there any difference in basic functionality or performance between:
- right-clicking on a table to use the data import widget
and
-using ncluster_loader from the command line
?

902 views
0 replies
How to identify a row ? Topic by ap90792 15 May 2015 aster column pseudo

Looking for a pseudo column/system column that helps to identify a row in a table in Aster database(similar to rowid in Oracle).Any inputs ?

1301 views
2 replies, 4 years ago
How to make proper visualization for a Sankey? Topic by ahadmushir 21 Jun 2015 Sankey, aster, Visualization

I am using the following No-Sql query to create a path to be displayed via a Sankey. 

1682 views
2 replies, 4 years ago
Install Aster Database on EC2 Topic by Marboni 25 Jun 2015 aster express, ami, ec2

Hi!
I already installed and played with Aster Express in VMware on my local machine. Now I need to install it on EC2 to make available for our demo server. Are there AMI files for Aster Queen / Worker nodes that I can use to deploy it on EC2?
Thanks, Boris.

891 views
0 replies
Connecting Aster Express 5.0.0 and Hadoop 2.0 VMWare and loading data with load_from_hcatalog Topic by Martijn 15 Jan 2014

I am trying to load data with the following statement:
SELECT * FROM load_from_hcatalog (on mr_driver server ('hadoop') username ('hue') dbname ('default') tablename ('sample_07') columns ('code', 'description', 'total_emp', 'salary' )) limit 5;
I get the following error:

2836 views
4 replies, 4 years ago
Can't access aster lens catalog Topic by ahadmushir 15 Jun 2015 aster, IP, asterlens

Can't access the aster lens catalog using the IP 192.168.100.150, although the AMC via the IP 192.168.100.100 is accessable. 

1657 views
4 replies, 4 years ago
Aster Connector for Oracle Topic by bcarlson 28 Apr 2015

The Aster 6.0 adn 6.10 database user guide FAQ says that there is an Aster Connector for Oracle.  What is it and how do we get it?  I can't find other references to it in the documentation.  it was also mentioned in an Analytics class that I am taking.
 
Brad.
 

1278 views
1 reply, 4 years ago
Aster express root passwords Topic by toadrw 05 Jun 2014 asterdata express logon

Hello:
What are the root passwords for the Asterdata Express VM Queen and Worker Images.  I read that root/aster worked in the past, but it no longer does.  Thank you.

2806 views
11 replies, 4 years ago
Loading a file to aster Topic by sunnysteve 06 Mar 2015

I am new to aster and trying to find out if we can load the JASON files in to aster ,If yes could some one guide me on that.

1232 views
1 reply, 4 years ago
KMeans Clustering problem in Aster Analytics Foundation 5.11 Topic by ahsan.khan 21 Oct 2014 clustering, Aster Analytics Foundation 5.11, teradata warehouse miner

I tried to do clustering on the iris dataset using KMeans clustering function in Aster Analytics Foundation 5.11. The problem I am facing is
1. For K=2,3,5, 10, upto 50 I just get one cluster with non-zero values.
2. For K=80 I get non-zero clusters, with total rows being 215, but understanding these 80 clusters is not possible.

1773 views
2 replies, 4 years ago
aster table usage Topic by fshpige 22 May 2015

Hello,
I'm looking for a way to find information about a set of Aster tables- specifically who(userid) queries them.
What would be  the best way to get this info?
 

1442 views
2 replies, 4 years ago
Create Test does not work Topic by Ingo 07 Nov 2014

Hey all,
 
I just created my first SQL MR function for Aster. I just wanted to define the corresponding test configuration.
When I click the "Finish button" the deployment zip is generated and also the in and out. However, the test file is not generated and the dialog also stays open.
Is this a known issue or do you have a hint what I might be doing wrong?

1626 views
2 replies, 4 years ago
Map Reduce Functions Topic by AxelJacquin 20 May 2015

Hello,
I am trying to use these function

SELECT * FROM SAMPLE(ON table SAMPLEFRACTION('0.2'));
or 

1352 views
1 reply, 4 years ago
How to see the DDL of a table in Asterdatabase Topic by shukla2502 20 May 2015 aster, Create table from NC_tables, Create table from Aster Metadata

Hi Team,
I was trying to look for the table definitions using the SQL but failed to do so..
 
I am aware about act command :  \d <schema> <tablename> but that will just show the components not the definition. L

1432 views
0 replies
Deployment Architecture of Aster when using Big Analytic Appliance Topic by abhishes 14 May 2015

Hi,
I saw a demo of Teradata Big Analytics Appliance. I was very impressed that you get Teradata, Teradata Aster and Hadoop in the same appliance. (wow)
But I have a few questions

802 views
0 replies
No space left on device error on select query Topic by Pradi 12 Jun 2014 aster express ; aster data

Hi,
I'm getting below error message on create and select statments.
ERROR:  could not extend relation base/16495/1249: No space left on device
Checked the disk space its not full.
aster -queen > df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda2       7.0G  4.4G  2.2G  67% /
devtmpfs        432M  172K  432M   1% /dev

1900 views
1 reply, 4 years ago
Connectivity between Aster 6.0 and HDP 2.1 Topic by Aastha007 05 Aug 2014

We were trying to establish connectivity between Aster 6 and Hadoop 2.1 for which we tried two approaches as mentioned below:
 
Approach 1: Connectivity through SQL-H
Issue with this approach: While making the host entry in Aster AMC I do not see HDP 2.1 version in the drop down. 
 
Exact error:

2807 views
6 replies, 4 years ago
Cannot Install Aster Drivers 6.0.0 or 5.1.1 Topic by nphillips8501 08 Apr 2015

I am trying ton install the Aster drivers 6.0.0.0 and 5.1.1 and I am receiving an error message that "This setup requires .NET Framework 2.0".  I already have .NET Framework 4.5 on my Windows Server 2012 Enterprise x64 on Amazon Web Services. Why is my .NET Framework 4.5 not being recognized?  Why does it have to be .NET Framework 2.0.  I cannot have two separate instances of .NET framework and

921 views
0 replies
Aster Database JDBC connection pool Topic by bibhu100 30 Mar 2015

 
Hi,
I was able to connect to aster DB via java application using the jdbc:ncluster connection string. Is there a way to use connection pool in my Java code for this aster database connection?
 
Thanks

1034 views
0 replies
1782 views
1 reply, 4 years ago
Aster tablesize and table owner SQL Topic by doneill@westpac.com.au 04 Dec 2014 administration

It's time for our developers to clean up after themselves. I want to produce a list of users, schemas, tables, size. Am I overcomplicating this? I've unsuccessfully tried the following:

2037 views
1 reply, 4 years ago

Pages