Home / CSE MCQs / Hive ::

CSE MCQs :: Hive

  1. Point out the wrong statement:
  2. A.
    There are four namespaces for variables in Hive
    B.
    Custom variables can be created in a separate namespace with the define
    C.
    Custom variables can also be created in a separate namespace with hivevar
    D.
    None of the mentioned

  3. A user creates a UDF which accepts arguments of different data types, each time it is run. It is an example of
  4. A.
    Aggregate Function
    B.
    Generic Function
    C.
    Standard UDF
    D.
    Super Functions

  5. What is Hive?
  6. A.
    An open source data warehouse system
    B.
    relational database
    C.
    OLTP
    D.
    An langauge

  7. _______ supports a new command shell Beeline that works with HiveServer2
  8. A.
    HiveServer2
    B.
    HiveServer3
    C.
    HiveServer4
    D.
    None of the mentioned

  9. The below expression in the where clause RLIKE '.*(Chicago|Ontario).*'; gives the result which match
  10. A.
    words containing both Chicago and Ontario
    B.
    words containing either Chicago or Ontario
    C.
    words Ending with Chicago or Ontario
    D.
    words starting with Chicago or Ontario

  11. The partitioning of a table in Hive creates more
  12. A.
    subdirectories under the database name
    B.
    subdirectories under the table name
    C.
    files under database name
    D.
    files under the table name

  13. The clause used to limit the number of rows returned by a query is
  14. A.
    Rownum
    B.
    Restrict
    C.
    Maxrow
    D.
    Limit

  15. In ______ mode HiveServer2 only accepts valid Thrift calls.
  16. A.
    Remote
    B.
    HTTP
    C.
    Embedded
    D.
    Interactive

  17. Which of the following scenarios are not prevented by enabling strict mode in Hive?
  18. A.
    Scanning all the partitions
    B.
    Generating random sample of data
    C.
    Running a order by clause without a LIMIT clause
    D.
    Cartesian product

  19. Calling a unix bash script inside a Hive Query is an example of
  20. A.
    Hive Pipeline
    B.
    Hive Caching
    C.
    Hive forking
    D.
    Hive Streaming