load data inpath 'dataDir/dim_url.csv' overwrite into table dim_url partition(day='2021-03')
注意:
1,以前都是加载本地数据,写法:
load data local inpath '' ...
2,如果加载hdfs上的数据,要去掉local
- 上传hdfs:hdfs dfs -put /dataDir/dim_urlAnalysisType.csv /user/root/dataDir
报错: put: Permission denied: user=root, access=WRITE, inode="/user/root/dataDir":hdfs:supergroup:drwxr-xr-x