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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum