The following is the statement that combines the INSERT and UPDATE statements into one.
UPSERT
INSUPD
MERGE
INUPDATE
To avoid duplication in the table, use -
IGNORE IF EXISTS
INSERT IGNORE INTO
IF NOT EXISTS INSERT
INSERT IF NOT EXISTS
Does ‘Anti Join’ perform better than left join?
Yes
No
Can't Say
Which of the following databases should be used to display built-in functions?
_hive_metastore
_impala_builtins
_impala_metastore
Derby
To print the create table statement for the existing table
PRINT CREATE TABLE [database_name].table_name
DISPLAY CREATE TABLE [database_name].table_name
DESCRIBE [database_name].table_name
SHOW CREATE TABLE [database_name].table_name
The command to refresh the metadata in Impala is-
refresh metadata <tablename />
validate metadata <tablename />
reload metadata <tablename />
Invalidate metadata <tablename />
LOAD DATA INPATH ‘/SampleData.txt’ INTO TABLE; This command is used to copy the file from
HDFS
Local File System
RDBMS
Hcatalog
Equal to, Not Equal to, Less than, Greater than - operators - are categorized as
Logical Operators
Comparison Operators
Arithmetic Operators
Equation Operators
Which of the following is not a complex data type?
Struct
Map
Array
BigInt
Which option allows you to run a single query without having to start the interactive interpreter?
-q
-impalad
run
-i