7.3. 执行Hive sql

在sql的一开始加上@hiveonly 或者 /@hiveonly/ 即可：

@hiveonly show tables; 

@hiveonly drop table xxxx;

@hiveonly CREATE external  table xxxx( 
   a1 double,
   a2 float,
   a3 bigint,
   a4 int
)
row format delimited fields terminated by ',' 
stored as 
  INPUTFORMAT 'cn.lucene.plugins.service.storageHandler.api.user.CLCombineInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' 
location '/data/xx/demo/xxx'
TBLPROPERTIES (
  'cl.combine.input.format.raw.format'='org.apache.hadoop.mapred.TextInputFormat'
);