- Hive catalog
Hive-conf-dir: /opt/cloudera/parcels/CDH/lib/hive/conf
CREATE CATALOG MyCatalog
WITH (
‘type’ = ‘hive’,
‘hive-conf-dir’=’/etc/hive/conf’,
‘hive-version’=’2.1.1’
);
USE CATALOG MyCatalog;
SET ‘execution.runtime-mode’ = ‘batch’;
SET ‘sql-client.execution.result-mode’ = ‘table’;
SET ‘table.sql-dialect’=’hive’;