Exit C2090-101 IBM Big Data Engineer
Question 4 of 5
0% complete
Q4 Single choice

A large bank was planning to offload existing data from a data warehouse into Hadoop and use SQL queries to access historical data.

Which one of the following statements is true for using HiveQL?

  • A

    It supports four logical operators in query predicates: IN, NOT IN, EXISTS, and NOT EXISTS

  • B

    It does not support nested sub-queries

  • C

    Hive supports all ANSI SQL 2011 syntax

  • D

    All of the above

Previous Next