Running Hive on Tez execution engine test

This section lists the steps to run Hive on Tez execution engine test.

1. Open the Tez execution engine interface.

   hive -hiveconf hive.execution.engine=tez

2. Create a remote database location on the remote HDFS Transparency cluster and create an internal partitioned table.

   Hive> CREATE database remote_db COMMENT 'Holds all the tables data in remote HDFS Transparency cluster'
   LOCATION 'hdfs://c16f1n03.gpfs.net:8020/user/hive/remote_db'
   OK
   Time taken: 0.08 seconds
   hive> USE remote_db;
   OK
   Time taken: 0.238 seconds
   hive> CREATE TABLE passwd_int_part (user_name STRING, password STRING, user_id STRING, user_id_info STRING,
   home_dir STRING, shell STRING) PARTITIONED BY (group_id STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ':';
   OK
   Time taken: 0.218 seconds
   

3. Create a local database location on the local native HDFS cluster and create an internal transactional table.

   hive> CREATE database local_db COMMENT 'Holds all the tables data in local Hadoop cluster'
   LOCATION 'hdfs://c16f1n07.gpfs.net:8020/user/hive/local_db';
   OK
   Time taken: 0.035 seconds
   hive> USE local_db ;
   OK
   Time taken: 0.236 seconds
   hive> CREATE TABLE passwd_int_trans (user_name STRING, password STRING, user_id STRING, group_id STRING,
   user_id_info STRING, home_dir STRING, shell STRING) CLUSTERED by(user_name) into 3 buckets stored as orc
   tblproperties ("transactional"="true");
   OK
   Time taken: 0.173 seconds