Questions tagged [impala]
Questions related to Apache Impala SQL Query Engine.
5 questions
0
votes
1
answer
163
views
Calculate (n) workdays from a given date, using a calendar table
As shown on below image, I have two tables;
Customer : with about 4 million records; and 3 columns
[Customer] : Customer ID
[Date] : Creation date
[Num_Days] : Number of working days to calculate ...
- 1
0
votes
0
answers
255
views
Get Join Keys dynamically from a table
SQL/Impala
I have a scenario where I need to join my input file with a mapping table which has map columns and derived columns. The join keys are dynamic and need to taken from a dynamic metadata ...
0
votes
1
answer
32
views
Retrieving orders that only contain certain product IDS
I am trying to retrieve a list of transaction IDS that only contain at least 5 product IDS, the baskets could have many more product IDS but it must contain these 5 also.
My table looks something ...
- 89
2
votes
1
answer
1k
views
how to insert data into extra columns of target avro table when source table is having less no of columns compared to target using hive or impala?
Suppose I am having a source Avro table having 10 columns and my target Avro table is having 12 columns, while inserting data into the target table I need to add null values to the extra 2 columns.
...
- 21
1
vote
1
answer
7k
views
Splitting a table into two tables randomly with 50-50 percent of records in impala
I have a table having n number of records in impala. I need to find out how can I divide that table into two equal halves with 50 - 50 percent of records in each.
- 11