命令
导出:
sqoop export --connect jdbc:mysql://localhost:3306/test --username root --password root --table test --export-dir '/user/hive/warehouse/test' --fields-terminated-by '\001' --input-null-string '\\N' --input-null-non-string '\\N' --input-lines-terminated-by '\n' -m 1
导入
mysql --》hdfs;
sqoop import --connect jdbc:mysql://localhost:3306/test--username root --password root--table test--as-textfile --delete-target-dir --fields-terminated-by '\001' --target-dir /user/hive/warehouse/test
hdfs -->hive 数据加载:
LOAD DATA [color=red]LOCAL [/color]INPATH 'dim_csl_rule_config.txt' OVERWRITE into table dim.dim_csl_rule_config;
其中local 是指本地磁盘。
导hdfs 只需
LOAD DATA INPATH 'dim_csl_rule_config.txt' OVERWRITE into table dim.dim_csl_rule_config;
load data inpath '/user/hdfs/user/hive/warehouse/myTable' overwrite into table myTable
导出:
sqoop export --connect jdbc:mysql://localhost:3306/test --username root --password root --table test --export-dir '/user/hive/warehouse/test' --fields-terminated-by '\001' --input-null-string '\\N' --input-null-non-string '\\N' --input-lines-terminated-by '\n' -m 1
导入
mysql --》hdfs;
sqoop import --connect jdbc:mysql://localhost:3306/test--username root --password root--table test--as-textfile --delete-target-dir --fields-terminated-by '\001' --target-dir /user/hive/warehouse/test
hdfs -->hive 数据加载:
LOAD DATA [color=red]LOCAL [/color]INPATH 'dim_csl_rule_config.txt' OVERWRITE into table dim.dim_csl_rule_config;
其中local 是指本地磁盘。
导hdfs 只需
LOAD DATA INPATH 'dim_csl_rule_config.txt' OVERWRITE into table dim.dim_csl_rule_config;
load data inpath '/user/hdfs/user/hive/warehouse/myTable' overwrite into table myTable