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