`jdbc:hive2://host:port/default;hive.auto.convert.join=false` but this also did not work.-- This sample requires a running HiveServer2 -->
<hive-client-factory id="hiveClientFactory" hive-data-source-ref="hiveDataSource"
data = load 'tablename'using org.apache.hive.hcatalog.pig.HCatLoader();Store finalresultinto 'tablename' USING org.apache.hive.hcatalog.pig.HCatStorer();
我能够通过org.apache.hive.hcatalog.pig.HCatLoader()从hive加载数据,但无法存储
我已经从一个配置单元table.then导出了数据,我创建了另一个表来读取这些文件。我的目标外部配置子母表也需要看起来相同。当我导出数据时,数组字段如预期的那样具有'[]‘。但是,因为我的目标字段也是一个数组,所以它添加了额外的'[]‘。我使用了转义方式,但找不到同时转义'‘和'’字符的方法。我已经使用了: FIELDS TERMINATED BY '\t' ESCAPED BY '['
COLLECTION ITEMS TERMINATED BY '\,'
ERROR [hive-demo] [Azkaban] Failed to build job executor for job hive-demoJob type 'hive' is unrecognizedCould not construct job[{hive.query.01: drop table words;, hive.query.03: describe words;, hive.query=HIVE_HOME
h