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
0
votes
1 answer

How do I compare two columns from two different tables

I am running a CREATE TABLE TBL AS SELECT statement as below. I want to write a CASE STATEMENT that will compare values from column X.PRESC_ID to values from column Y.PRSC_NPI and if there is match, it should INSERT to TBL.PRESC_ID, and for all…
Bond
  • 25
  • 2
  • 13
0
votes
1 answer

How do I prioritize date format 'MM/DD/YYYY' over 'MM-DD-YYYY'

How can I write a query in Teradata so that if the field Cont_Num has duplicate with different data formats('MM/DD/YYYY' and 'MM-DD-YYYY'), the query should only return the field with date format 'MM/DD/YYYY', but if there are no duplicates for…
Bond
  • 25
  • 2
  • 13
0
votes
0 answers

working in Teradata and having an error message 'Target row updated by multiple source rows'

Help Please I am working in Teradata and I get the error message 'Target row updated by multiple source rows', what could be causing this? Here is the code I am using UPDATE USS_MISC_STAGE.RXA_RX_CLAIM_PRSCRBR_XREF FROM ( SELECT…
Bond
  • 25
  • 2
  • 13
0
votes
1 answer

Teradata update recursively

I have data record like this and I want update blank record from previous filled record enter image description here ID L_nbr Code Descripton t001 5 S001 ABCDE t001 12 S002 FGHI t001 15 JKM t001 17 …
vinothbabu
  • 23
  • 1
  • 3
0
votes
0 answers

Unable to Insert Dataframe into Database Table

I am trying to insert my dataframe into a newly created table in Teradata. My connection and creating the table using SQLAchmey works, but I am unable to insert the data. I keep getting the same error that the schemy columns do not exist. Here is my…
Maria Nazari
  • 660
  • 1
  • 9
  • 27
0
votes
0 answers

Add if/else filter

I have the following script: SELECT * FROM ( SELECT distinct web_product_source_id, recipe_id, cos_score, row_number() over (partition by web_product_source_id order by cos_score desc) as rnk FROM ( …
Maria Nazari
  • 660
  • 1
  • 9
  • 27
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
1 answer

Can we write bteq on Teradata Aster node

I am trying to take the backup of DDL of all of my schemas in Teradata Aster. I know how to take it manually but can some please tell me how i can write bteq on Aster.
user3916316
  • 1
  • 2
0
votes
1 answer

Using documentParser function in Teradata Aster

I'm working with Teradata's Aster and am trying to parse a pdf(or html) file such that it is inserted into a table in the Beehive database in Aster. The entire pdf should correspond to a single row of data in the table. This is to be done by using…
Hela
  • 1
  • 2
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

Is it safe to use multiple symbols hits per row in the Aster nPath algorithm?

On page 77 of the Aster Analtyics users guide: http://www.info.teradata.com/eDownload.cfm?itemid=122580002 it says: “Note that the predicates for different symbols may overlap, and therefore multiple symbols may match the same row.” Does anyone have…
Frank McQuillan
  • 61
  • 4
0
votes
0 answers

Teradata / Aster: How do i setup tab delimited output when using ACT tool of Aster DB?

I want to export aster tables into tab delimited files, each file containing just 100 records. Hence i'm using ACT Tool as i cannot specify an SQL (select * from table_name limit 100) with ncluster_export tool. One issue i'm facing is when…
Vaibhav
  • 123
  • 1
  • 6
0
votes
2 answers

Teradata / Aster : Fast Export / ncluster_export using query

I am trying to export a query from Teradata Studio 14.10 / Aster using the ncluster_export command line function. I can't find a working example to go off of. Does anyone have one they could share? Also how would I actually run the script (ie…
screechOwl
  • 27,310
  • 61
  • 158
  • 267
0
votes
1 answer

Ranking rows and selecting one

I would like that the rows are ranked on Aspez_ID attribute, and that only one row which has ASpez_ID = 1 is selected. The thing is - I want to select one and only one row from the dataset. Can you please help me? Here is the code: LEFT OUTER JOIN…
Dantes
  • 2,791
  • 6
  • 26
  • 34
-1
votes
2 answers

Difference between Aster Data and Hadoop/Hive

All the components in Aster Data seems to have a similar component in Hadoop stack. AFS => HDFS SQL-MR => Hive AMC => Ambari ACT => beeline/hive terminal Postgres for storing metadata => Hive can be configured to store metadata in any…
ernesto
  • 1,899
  • 4
  • 26
  • 39
1
2