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