CREATE EXTERNAL TABLE IF NOT EXISTS vehicleTable (TYPE STRING, MAKE STRING, MODEL STRING, CLASS STRING, COLOR STRING, PRICE DOUBLE, COUNT INT) STORED BY 'oracle.kv.hadoop.hive.table.TableStorageHandler' TBLPROPERTIES ("oracle.kv.kvstore" = "kvstore", "oracle.kv.hosts" = "localhost:5000", "oracle.kv.tableName" = "vehicleTable", "oracle.kv.hadoop.hosts" = "dn-host-1,dn-host-2,dn-host-3");