Hi, 1. Hive 3.x needs hadoop 3.x, but our project is based on the hadoop 2.x, and these two are incompatible.
2. Now, we don't support insert operation in hive. Only query operation is supported. 3. If there are more than one tsfile in one folder, all the tsfiles in that folder will be pre-read by InputFormat, and then filter them by the table name(i.e. device_id) and the field (i.e. sensor_id). So the result set returned to user will only contains data they want. > -----原始邮件----- > 发件人: "Xiangdong Huang" <saint...@gmail.com> > 发送时间: 2019-10-12 14:38:36 (星期六) > 收件人: dev@iotdb.apache.org > 抄送: > 主题: Questions about Hive Integration > > Hi, > > Today I meets some users from Inspur (a famous Chinese company), and they > address some requirements about IoTDB with Hive. > > 1. First, they use hadoop 3.x. > > 2. Can we use Hive to write data back to HDFS with TsFile format? > e.g., HiveQL: create table ..... LOCATION HDFS_FILE > > 3. If Hive user uses Load command from a IoTDB's data folder, what happens? > E.g., HiveQL: load data inpath 'iotdb/data/root.sg1/' into table > tablename... > Then, which Table files will be observed by Hive? If more TsFiles in the > folder are generated by IoTDB, can Hive observes them automatically? > > Best, > ----------------------------------- > Xiangdong Huang > School of Software, Tsinghua University > > 黄向东 > 清华大学 软件学院
