in Big Data | Hadoop by
Q:
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
Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

+1 vote
asked May 7, 2020 in Big Data | Hadoop by GeorgeBell
0 votes
asked Jan 13, 2020 in Big Data | Hadoop by AdilsonLima
0 votes
asked Apr 6, 2020 in Big Data | Hadoop by GeorgeBell
0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
...