寒夜二十五

当oracle用户A创建一张表,想给用户B赋权的命令：grant select,insert,update,delete on ownerA.tableA to owner

查看oracle中的表的字段类型的sql:select COLUMN_NAME,DATE_TYPE,DATA_LENGTH,DATA_PRECISION from all_tab_columns

当报表找不到的错误时（table is not exist...）解决方法：

1.oracle导入到hive脚本/home/sqoop/sqoop-1.4.7.bin__hadoop-2.6.0/bin/sqoop import--username admin--password '123456'--connect jdbc:oracle:thin:@192.168.127.1:1521/数据库名--fields-terminated-by '\001'--null-non-string '\\N'--null-string '\\N'--dele.