hive语句和oracle一样吗

hive语句和oracle一样吗

目前我知道的方法是把你希望添加的数据写入到文本中，然后从文本导入到你的表格中。 但是，hive不知道oracle的insert into , update。 load data [local] inpath 'yourfile_location' [overwrite] into your_table;

[steps] 1. install oracle 11g for 32bit on a windows 32bit vm (windows server 2003) see <在windows server 2003 32bit 中安装oracle 11g 32bit>: http://blog.csdn.net/mozart_cai/article/details/8596352 2. configure local listener(本地监听服务) in oracle net manager, add a listener see <通过net manager 配置oracle 11g本地监听服务(listener service)>: http://blog.csdn.net/mozart_cai/article/details/8596504 3. load oracle table to hive table via sqoop in oracle sql plus, check all tables owned by current user sql> select unique tname from col; we choose table "dept" to migrate. in cluster node $ hive $ show tables; $ quit; $ sqoop import --connect jdbc:oracle:thin:@ipaddressofnodeinstalloracle:1521:orcl --username scott --password 123456 --table dept -m 1 --hive-import --hive-table "hivetest" notice: ipaddressofnodeinstalloracle is for windows run oracle(ex: 172.16.3.4); username and password are configured in oracle;tablename and username should be upper case $ show tables; $ select * from hivetest;