Hi,
i need to have a complete log for the system and users activities on ASTER.
i need it because after a shutdown in the weekend, i think for too many sessions or too many work space used, i can't find the real cause because the table of the statements don't save any more this data.

Hi All,
I have downloaded the Aster express and followed all the instructions to configure the VMware and also started the queen and worker nodes but when I use the https://192.168.100.100/ URL to open the AMC it does not open the console. I tried using IE9 and Google chrome both but none of them worked. Any suggestions/help will be really appreciated.
Thanks

Hi All,

We are trying to read data from Hive table and load into teradata table after lots of transformation. So, we are trying to use "load_from_hcatalog". But while selecting data, we are getting below error:

Dear Aster gurus,
A very newbie question: how to visualize the rresult of an nTree function? I have a table with parent-child relationships, could build a nice graph (dependency list from the "bottom"), now I would like to see a graph, where these dependencies are visuallized. A Sankey or a Sigma chart would be OK.

Hi Team - i have a string field with about 600,000 rows like the below. Aster data base is connected through Teradata Studio.
Text1,Text2,Text3
Text1,Text2
Text1,Text2,Text3,Text4,Text5
I need each date in a different column, i tried strtok but Teradata studio gives me an error that it does not support strtok. Can anyone please help. thank you.

Hi,
I'm trying to use code assist for displaying a list of table after writting my database name. However code assist is not working, i'm on teradata studio express v15.11, any help ?
-> Code Assist is activated
-> Connection profile is ok
Thanks,
Dan

The Teradata Certified Professional Program is excited to announce the release of  the first Teradata Aster Certification Exam – Teradata Aster Basics 6.10.  Passing this exam will earn you the Teradata Aster Certified Professional Credential.  Start preparing today and you’ll be one of the first to get Teradata Aster Cert

Hello,
when running the ncluster_export for a database object containing uppercase letters, the object name gets translated to lowercase even if double quotes are used, resulting in a failure to find the object.
Example:
 

Hi,
In porject, I use the Table visualizer and like to download the data.
Our customer data is Han-gule and it is multi character set. If the data is english character then ok. But Han-gule data is broken.  
How can I solve this problem?
 

I'm having trouble allocating database space on aster when I create new db, schema or table. At what level can you allocate disk space (assuming at db level) and how can this be done? I'm using db super user credentials. Thanks.

Hi,
I installed the UDA on a Stick package and run currently some of the examples.
TD15.0 and Aster 6.0 are runing and working fine.
HDP2.1 is also running. And hive is working on the HDP2.1 - I can run select * from freeze_frames from the hive consol and get results.
But when I run 
select * FROM load_from_hcatalog
(on mr_driver

Hey everyone,

In Aster DB ,Use Teradata Studio use AnyDatabase2Aster function running a query statement, search oracle data. Following:
select * from AnyDatabase2Aster
(on (select 1) partition by 1
automap('true')
configfile('connector.conf')
instance('orc_gmcc')
USERNAME('his')
PASSWORD('his')
DBNAME('bigdb')
DBTABLE('ARC_S_95598_WKST')

I've started building some visualizations in Teradata App Center using Aster, and I'm running into an issue. The viz type I'm using in this example is a Sankey diagram. The visualization is generating correctly, but unfortunately, the data points are spreading WAY far apart, making a relatively small amount of data impossible to see all at once. I've attached a picture showing the issue.

Is there a way to find the Create timestamp and Last Modified timestamp of a table?

We have implemented both data roles and user roles in Aster. I wanted to create some way to make it easy for users to apply the proper grants to their tables when they're ready to allow others access to the tables. Generally, I'd write a procedure that takes in the schema name and table name and would dynamically create and execute something like:

Hi
I have Aster express on my desktop and would like to upload JSON objects from a file to a Table on ASTER. Datatype JSON is not supported, and I tried using VARCHAR, but it did not work. JSON got corrupted when I did so..
What is the best way to load a JSON object to ASTER Table from a file...(for example: from twitter dump file)
Thanks in advance
Regards

Hi,
I have noticed that INSERT with bracketed query is supported what is not documented in Aster SQL reference:
- INSERT INTO table (query)
Should I treat this as a bug or another syntax not included in the documentation set?

I am unable to get a stored procedure call that returns a dynamic data set to execute from Aster via the TDConnector. Is this becasue the QueryGrid function load_from_teradata only supposts a SQL Select statement, period? If so, is there any other method or function that can call a TD SP to return data to aster and load into an Aster table?
 

There is not system view to list all sequences.
I found some information inside nc_all_columns but Aster provides GRANT on sequence without simple way to identify their names.

Dear community,
for one of my customers I am looking for best practices and guidelines for loading data with Informatica PowerCenter into Aster.
Any feedback or guidance on this would highly be appreciated.

Hi guys,
 
I am new to Aster. Only like 3 weeks into it.
I am using TEXT_Parser analytic function. I want to use my own stop word file.
I have loaded the file from my local into AFS using this command:
 \afs -copyFromLocal ./Test/stopwords_en.txt adfs:///

Hi,
I need to load an xml file in Aster Database
I need to use functions like XMLParser OR XMLRelation.
But both the above functions need a table as input. So how do I get this xml file into a table
 
Thanks,
Jeetu
 

I tried to get data from nc_all_users using pyodbc where only cursors are available for tetch data. Unfortunatelly AsterDB returned error:
('HY000', '[HY000] [AsterData][nCluster] (34) ERROR: declare cursor statement may not reference system tables.  (34) (SQLFetch)')
Any idea how to get data from system tables using Python?

I've followed the "getting started" instructions for Aster Express. I'm using 5.0express-r29890.
Successfully added the Worker node but when I click on "Activate Cluster" I always get "Failed to start cluster activation" in the status bar. I saw during start-up of the worker node that the nCluster service failed to start.