All Forums

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

You must login to post to the forums.
Aster Express installation Topic by Pradi 18 Apr 2014 aster express

Hi,
I'm trying to install Aster Express V6 but after installation the AMC is not working.
I've tried https://192.168.100.100/  , http://192.168.100.100 , https://192.168.100.100/chrysalis/login all these urls but still not working.

1014 views
0 replies
Replace all characters in string except particular words Topic by nurandi 27 Feb 2014

Dear All,
I am trying to replace all characters in string except particular words using regexp_replace() function in Aster.
For example, replace all chars in string "I will go to Jakarta, Bandung and Bali next month" with "X", except "Jakarta", "Bandung" and "Bali". So, expected result will be "X JakartaX Bandung X Bali X".

2192 views
3 replies, 5 years ago
Teradata Aster SQL-GR™ Topic by Raja_KT 11 Apr 2014

I am looking at some detailed documents on SQL-GR since I am comparing with Neo4j. Can you please share any pointer for me?
Thanks,

924 views
0 replies
Some interesting Workload Manager "Hacks" Topic by mcooper@intellicog.com 05 Apr 2014

(Disclaimer: There's no actual "hacking" involved here.  Just using WLM in a slightly less-than-obvious way)
 
Hack #1 - Say you have a class of users who can be trusted to know what priority their queries should run at.  You want to give them control, but how can you do that?  Here's one solution that uses a combination of roles and WLM policies:

1131 views
1 reply, 5 years ago
nc_system Tables/Views in Aster Topic by grishma 27 Mar 2014

Is there a document where i can see all the different nc_system schema objects? I am using TD Studio and i am able to view many of the nc_system views, However, there are few tables like "nc_all_sessions".
I would like to get a list and details of all objects in nc_system schema.

1323 views
1 reply, 5 years ago
Custom Alerts Topic by mandre 25 Mar 2014

We are using all of the "out of the box" AMC alerts.  Does anyone have any suggestions or would like to share any sources, tools, or custom scripts they have wriitten to give alerts on Aster?  For example we recently had a file system fill up.  We also have situations where other resources are peaking: cpu, memory etc. 

800 views
0 replies
Where is Aster Express? Topic by makaveli0129 19 Mar 2014 aster express, aster data, naive bayes

I downloaded the aster Express from http://www.asterdata.com/download_aster_express/ but this is version 5.0 which is really old. Is there a newer version somewhere?
 
Also, the images do not contain the naiveBayesPredict.jar file in the /home/aster/demo/Analytics_Foundation.zip. Any idea on where i can get this?

1062 views
2 replies, 5 years ago
Issue Loading from Teradata Topic by makaveli0129 12 Mar 2014

I'm trying to load a table from teradata using the below:
 
create table test_table distribute by hash(field1)
as
select *
from load_from_teradata(
on mr_driver
TDPID('hostname')
logon_mechanism('ldap')
username('user')
password('password')
query

983 views
0 replies
Data Movement from Teradata to HDFS (Hadoop) Topic by RandomCipher 12 Mar 2014

Hi All
I am new to Teradata Aster . My company is planning to move the Datawarehouse data Inside Hadoop (HDFS).
Can Aster directly take data from Teradata and Insert into HDFS ?  if so can you shed me more details on the same.
If so will it be faster than INFORMATICA creating the File and Pushing to HDFS.
Thanks
 
 
 

832 views
0 replies
Ncluster loader and merge Topic by shripadpawar 25 Feb 2014

Hi experts,
 

1209 views
0 replies
How to create and deploy an ordinary function (not a sql/mr function) in Aster Topic by p620121 05 Feb 2014

I would like to create a regexp_replaceAll funciton, but as a regular database function, not an sql/mr function.
Aster has a built-in regexp_replace function which is inadequate for my needs.

826 views
0 replies
Could you please help to install Aster Data Developer Expresee plugin Topic by Anubeig 28 Jan 2014

Could you please help to install Aster Data Developer Expresee plugin .
I need Eclipse 3.5.1 right .I have eclipse tell me the procedure and also give me the download link for Aster plug-in's

937 views
0 replies
Aster without a SYS_CALENDAR? Topic by JBerry003 27 Dec 2013

Is there a default system calendar table in Aster that can be used similar to Teradata, or must we create a replicated xref table explicitly?

1177 views
2 replies, 5 years ago
Hive Views in Aster Topic by td_admirer 15 Jan 2014

Hi Team,
Can someone please tell me if Hive Views are supported in Aster? It throws me an error message and I do not seem to understand it.
Executed as Single statement.  Failed [34 : HY000] [AsterData][ASTERJDBCDSII](34) ERROR: failed to access hcatalog table hive_view_v: FAILED: Error in metadata: java.lang.NullPointerException ()
Thank you in advance.

1283 views
1 reply, 5 years ago
Connection between Aster and Hadoop Topic by kobiattia 01 Jan 2014

Hi Everybody,
If I have a Hadoop with 900 TB and Aster with 100 TB and I run  a query using function load from hadoop, the data will be copied to Aster cluster or the query will run in Hadoop cluster?
 
If it run in Aster, how is the mechanism to copy a big quantity of data into Aster Cluster?
Thanks and happy new year :)
Kobi

1118 views
2 replies, 5 years ago
Worker is Passive mode Topic by vishaljain000 16 Dec 2013

HI,
I am trying Aster Express & downloaded virtual images for it. First time I am able to start Queen & worker. But after 3 dats when I am trying to start Queen & worker then Queen is Up but Worker is showing as in Passive mode. I have configure only one worker. what all paramaters affected worker to set as PAssive & how can I get it to Active mode.?

1471 views
3 replies, 5 years ago
"load_from_teradata" error Topic by Tomas.Li 23 May 2012 load_from_teradata

Hi All,
I got the follow error in using "load_from_teradata" function:

My SQL statement:

CREATE FACT TABLE empty(
UserId int
)
DISTRIBUTE BY HASH(UserId);

8755 views
8 replies, 5 years ago
Data Migration from Oracle/SAP to Teradata Aster Topic by chaitanyakmr_man 05 Jan 2014

HI Team,
 
I want to move data from Oracle/SAP to Teradata Aster.
I had migrated some data by Exporting to CSV files then import to Teradata Aster, but I see, it is not a very good option, when the size of the data files is large like 100 GB.

1370 views
1 reply, 5 years ago
moving data from hdfs to aster : Open discussion - All are invited ( or should I say requested ) Topic by Boulderman 05 Jan 2014

apart  from the inbuilt aster  loading functions invoked via queries and the  aster native loading tools - what are some other ways to get data from hdfs to aster. I opened this discussion to  discuss the pro's cons's approrpriatess vs futility  of each method.
Lets brainstorm , folks ...
 

940 views
0 replies
Cannot create a model Topic by p620121 16 Dec 2013 aster, model, trainednamedentityfinder

Hi, I'm new to Aster, but I've been working off the examples in the Aster_Analytics_Foundation pdf and I'm having trouble creating any kind of model. I have all the permissions I need and all functions were installed and I have access to them, but when I try to create a model, as with the TrainedNamedEntityFinder, for example, the job runs, but there is no output, no file created.
 

1247 views
2 replies, 5 years ago
Aster Express Installation on VM Topic by vishaljain000 16 Dec 2013

Can I have steps for Aster express installation on Linux OS.? I don't find it.
I see we can run Aster express just from desktop/laptop machine, Can we run from VMware machine.?

1162 views
1 reply, 5 years ago
Load_from_teradata : problem with quote marks in the query Topic by jjacquot@adequacycs.com 12 Dec 2013 aster, load_from_teradata, quotes

Hi everyone,
I want to execute the following Teradata request in a load_from_teradata in an Aster request, but i have an error because of the quote marks in the filter :
select * from load_from_teradata (
ON mr_driver TDPID('PROD') username('aster_dapp_tec') password ('****')

                query ('select c.id_diffusion, e.lib_categorie

1554 views
1 reply, 5 years ago
Help: Stream SQL-MR using Python. Topic by rp186020 18 Dec 2012 python, aster, sql-mr

Hi,
I'm a Python dev for the past couple of years and connecting to PostgreSQL using the psycopg2 module.
Now, I'm using Teradata Aster, as my training, I tried creating a simple sql-mr function using a python. Given the table, the sql-mr will populate the tables with random values.
What do I need to connect to a Aster Database?

6241 views
1 reply, 5 years ago
ODBC Connection error Topic by fcavalie@us.ibm.com 23 Jan 2013 odbc, invalid string, invalid buffer length, invalid string or buffer length

Hi all,
I'm trying to create a simple ODBC connection using a couple of 3rd party tools called:  Aqua Data Studio and Razor SQL.   First, I followed the steps in the Aster nCluster user guide to create the DSN ODBC connection on a Windows 7 x64 SP1 desktop.  I was able to test the connection succesfully.

2831 views
1 reply, 5 years ago
Teradata Aster: Transfer files from local host to VM Topic by Ankit Jain 25 Apr 2013

Hi All,
I have windows xp operating system with 64 bit on which i have installed VM player. I have setup Teradata Aster with  queen node and worker node with the following IP 192.168.100.100(queen) and 192.168.100.150(worker).  

2301 views
5 replies, 5 years ago

Pages