花影重叠吧 关注:81贴子:561
  • 3回复贴,共1

beeline 执行数据导入load data报错No files matching path file

只看楼主收藏回复

https://blog.csdn.net/hao495430759/article/details/80529456 此帖子差不多,报错
Error: Error while compiling statement: FAILED: SemanticException Line 1:23 Invalid path ''/user_yddsj/xxx/loadcsv/cfg_siteinfo_tdlte.csv'': No files matching path file:/user_yddsj/xxx/loadcsv/cfg_siteinfo_tdlte.csv (state=42000,code=40000)
报错找不到文件,确定当前机器确实存在这个文件。
解决方法二:先将本地文件上传至hdfs,然后使用 load data inpath [hdfspath] [overwrite] into table table_name.


IP属地:北京1楼2018-10-11 11:06回复
    IP属地:北京2楼2018-10-11 11:22
    回复
      本地上传hdfs:hdfs dfs -put /user_yddsj/xxx/loadcsv/cfg_siteinfo_tdlte.csv hdfs://nameservice1/user/user_yddsj
      放这里:hadoop fs -ls hdfs://nameservice1/user/user_yddsj
      得到:hdfs://nameservice1/user/user_yddsj/cfg_siteinfo_tdlte.csv


      IP属地:北京3楼2018-10-11 11:23
      回复
        hadoop fs -ls /data/user_yddsj
        hadoop fs -put ./cfg_siteinfo_tdlte.csv /data/user_yddsj
        LOAD DATA INPATH '/data/user_yddsj/cfg_siteinfo_tdlte.csv' INTO TABLE cfg_siteinfo_tdlte;
        传错位置了,传hdfs --/data/user_yddsj里即可


        IP属地:北京4楼2018-10-11 15:26
        回复