0 votes
in Big Data | Hadoop by
Consider the below two sets of queries.

Query A:

hive> INSERT OVERWRITE TABLE sales

SELECT * FROM history WHERE action = 'purchased';

hive> INSERT OVERWRITE TABLE credits

SELECT * FROM history WHERE action = 'returned';

and

Query B:

hive> FROM history

INSERT OVERWRITE sales SELECT * WHERE action = 'purchased'

INSERT OVERWRITE credits SELECT * WHERE action = 'returned'

Which of them will make a single pass through?

A - Query A

B - Query B

C - Both

D - None

1 Answer

0 votes
by
Query B

Related questions

0 votes
asked Apr 8, 2020 in Big Data | Hadoop by GeorgeBell
0 votes
asked Apr 7, 2020 in Big Data | Hadoop by GeorgeBell
...