Stack Overflow
Stack Overflow

Questions tagged [aster]

The Teradata Aster Discovery Platform is the market-leading big data analytics solution. This analytic platform embeds MapReduce analytic processing for deeper insights on new data sources and multi-structured data types to deliver analytic capabilities with breakthrough performance and scalability. - See more.

27 questions
0
votes
1 answer

Cannot connect to Teradata database through JDBC (Connection broken)

I'm trying to connect to a teradata database, i've followed the documentation example, and other examples on the web, but i cannot connect String host= "X"; int port=XXXX; String database="X"; String username = "X"; String…
Sim Hm
  • 97
  • 3
  • 13
0
votes
0 answers

Rounding issue with R, raster, and lat-lon-data

I am importing and exporting ASTER digital elevation models in R using the raster package. These data have a geographic coordinate system, so that the extent of the raster and its cellsize are in degrees. I find that there must be some kind of…
GeVe
  • 1
0
votes
1 answer

How can I set query_band for Block Level Compression using Aster's load_to_teradata function,

When you are loading a teradata table in bteq you can set the queryband for block level compression. This even works when you are using querygrid and inserting from a foreign server. SET QUERY_BAND = 'BlockCompression=Yes;' UPDATE FOR SESSION; My…
Daniel Patriarca
  • 361
  • 3
  • 20
0
votes
1 answer

Alter Table Column Type Does not Work in Aster - I am Probably Screwing It Up

I am using Aster as there are some groovy Random Forest Functions to use. My dependent, or response variable, is a boolean dichotomous variable; a 0 or 1. When I run it through the Random Forest Function of choice it creates a predicted value of the…
Zach
  • 37
  • 8
0
votes
1 answer

How use sql in Teradata with Aster database?

Currenly I use Teradata Studio, and I want to use table in Aster, it's possible to create dblinks or other configuration to call tables from Aster database to Teradata database into Teradata Studio?. Thanks.
Victoria Ubaldo
  • 99
  • 1
  • 13
0
votes
1 answer

Aster UPDATE Column Does Not Exist

I am attempting to UPDATE the values of a column in one table based on the count of values in a source table. I am using Teradata Aster. When I submit the following correlated subquery, I get an error stating the column does not exist despite…
Daniel
  • 691
  • 2
  • 8
  • 19
0
votes
0 answers

d3js Aster Plot label text wrapping

We are currently designing Aster Plot using D3Js. There is a requirement to wrap label text with orientation. The orientation is achieved but issues with wrap. Now it looks like Current Aster Plot and the output should look like as shown in Output…
Amar Chand Nagisetty
  • 1
  • 1
0
votes
2 answers

Python and nGrams

Aster user here that is trying to move completely over to python for basic text analytics. I am trying to replicate the output of ASTER ngram in Python using nltk or some other module. I need to be able to do this for ngrams of 1 thru 4. Output to…
Josh Chilton
  • 13
  • 1
0
votes
0 answers

Creating tables in aster very slow using hash table and join

I am doing a simple join on two tables in SQL which works fine, but when try to create a table using the same join it runs very slowly/never completes execution. create table trial distribute by hash(key1) as select a.*,b.item2 from table1 a …
laila
  • 1,009
  • 3
  • 15
  • 27
0
votes
1 answer

Teradata Aster ACT grant access to functions and view installed files

I've created a new database and installed Aster Analytics function packages (foundation, PremiumPath...etc) onto the public schema. I know the grant function access command: grant execute on function schema.function to user-group; Is there a way to…
kuropon
  • 35
  • 3
0
votes
1 answer

Extract data in Aster Teradata?

i have a time series data like the above one. T0,T1,… represents the Date on which a ticket has been submitted to stage 1, stage 2 and so on.. All i need to do is find the time spent in each stage, provided that following all the stages is not…
Saurav
  • 597
  • 10
  • 24
0
votes
1 answer

Classifying the values present in a single column using SQL into their respective datatypes?

I have been trying to classify the a set values present in a single column (just like above) into datatypes. The problem being that i am using Aster SQL environment (availability of function and the environment as a whole is very limited). Another…
Bflat
  • 47
  • 1
  • 10
1
2