Questions tagged [sql-mr]

map-reduce framework integrated within Teradata Aster SQL database

3 questions
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
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