Stack Overflow
Stack Overflow

Questions tagged [teradata-aster]

The Teradata Aster Discovery Platform is the market-leading big data MPP database platform incorporating relational and Hadoop technologies and data stores coupled with advanced map-reduce and graph processing engines.

User for questions about the Teradata Aster Discovery Platform, a big data MPP database platform incorporating both relational and Hadoop technologies and data stores.

30 questions
2
votes
0 answers

How to remote access Aster express through ubuntu?

I am using latest version of Aster express edition form Teradata and configured, which is run only in windows so create a virtual machine of windows on my Ubuntu machine, and its perfectly working in SUSE (using Aster Client Tools - ACT) and windows…
Kaushal
  • 3,237
  • 3
  • 29
  • 48
2
votes
1 answer

In Aster, how do I use CREATE TABLE IF EXISTS and what version of postgres am I using?

We're using Aster for some of our web session logs. I've been told internally that Aster uses PostgreSQL, and in fact for a lot of my queries, I look on this site and follow the guidelines for PostgreSQL code, which always work. Now, I'm trying to…
Rick LaPointe
  • 73
  • 1
  • 2
  • 6
1
vote
0 answers

A character string failed conversion to a numeric value: Teradata insert

I am trying to execute the insert statement in teradata and getting the error message 'A character string failed conversion to a numeric value' INSERT INTO USS_LOAD.RX_CLAIM (RX_CLAIM_PRCSR_PRTY_ID,RX_CLAIM_PRCSR_ORGN_NM,…
Bond
  • 25
  • 2
  • 13
1
vote
1 answer

Connecting to Aster Teradata Python

I want to connect to Teradata Aster, I have been searched through multiple sites and read documentation but with not luck. I am able to connect to Teradata just fine, but not to Aster Teradata. code for teradata that works, but I don't know how to…
Maria Nazari
  • 660
  • 1
  • 9
  • 27
1
vote
3 answers

SQL Update Multiple Rows with Count from another Table

Suppose I have two tables. One table, tbl1, is "long" and non-aggregated. The structure is as follows: Software_Name: Word PowerPoint PowerPoint Excel Word PowerPoint In a second Table, tbl2, I want to summarize the data from the first table,…
Daniel
  • 691
  • 2
  • 8
  • 19
1
vote
4 answers

How to copy column names from Teradata

I want to export the column names into excel sheet by running the query in Teradata. I used ctrl+c but it didnt work. Thanks in advance.
ecenurozturk
  • 31
  • 2
  • 8
1
vote
2 answers

Not able to connect to Aster database through jdbc driver using java

I am trying to connect to Aster server with jdbc drivers from java. I have added already the Jar files to the classpath. import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import…
Ramineni Ravi Teja
  • 3,568
  • 26
  • 37
1
vote
3 answers

Aster Data belongs to which Database family

I know Aster Data leverages SQL Map Reduce, ncluster and analytic capability. From Database architecture perspective which family does Aster belongs to?
Shiva Achari
  • 955
  • 1
  • 9
  • 18
1
vote
1 answer

How to create a temp table in teradata

BEGIN; CREATE TEMP FACT TABLE new_table DISTRIBUTE BY hash(a.var3) as SELECT (YEAR(a.var1) - b.var2), a.var3 FROM d.data1 a, c.data2 b WHERE (YEAR(var1) - var2) > 40 ; GO SELECT * FROM age_DRG; END; I am not sure what is wrong with this code. I…
ChrisYee90
  • 389
  • 1
  • 6
  • 12
1
vote
1 answer

How can I calculate an aggregation with the Aster Basket_Generator function

I'm using the Aster Basket_Generator function to calculate a basket from a table of purchases (retail_purchases). I can create the basket without issue using the following code: SELECT order_number, gsi_sku1, gsi_sku2, Count(1) FROM…
TWAndrews
  • 113
  • 1
  • 4
1
vote
2 answers

What is the difference between apache hive and Aster data in terms of analytic functions?

I came across something which showed that you can write analytic functions in Hive. For example: for a wordcount example, we can write in hive as well. the difference would be that in Aster data it is already in-built whereas in hive we have to…
NJ_315
  • 1,863
  • 7
  • 22
  • 30
1
vote
3 answers

Errors while trying to cast/convert VARCHAR to DATETIME in ANSI SQL

I have a column in a table where timestamps have been stored in VARCHAR format, but I need to compare these against a column of DATETIME values from another table to find time intervals, so I want to either cast or convert the VARCHAR timestamps to…
Stanley Ayzenberg
  • 25
  • 1
  • 7
0
votes
1 answer

How do I Select all duplicates

I am trying to develop a DMR from the DMR #1 which return all the data which are identified by DMR #1 so that I can load them to a work table and then delete the duplicates before inserting back to the main table. So I have DMR #2 but when execute…
Bond
  • 25
  • 2
  • 13
0
votes
1 answer

How to decare a variable in Teradata sql and call them in a select statement?

I want to declare two variable and use thoes variable in where condition of a select statement in teradata, but I am getting an error in that. Create Procedure Demo() Begin Declare REnd Date; Declare RStart Date; Set REnd = (select…
Sufiyan Ahmed Shaikh
  • 1
  • 1
0
votes
0 answers

Expecting something between ')' and the 'AS' keyword

I am trying to run the update query below in Teradata but getting an error message 'Expecting something between ')' and the 'AS' keyword. I am missing anything? I have checked some previous update and it worked for other developers in my company. …
Bond
  • 25
  • 2
  • 13
1
2