Re: pyspark sql load with path of special character

2021-04-25 Thread Stephen Coy
It probably does not like the colons in the path name “…20:04:27+00:00/…”, especially if you’re running on a Windows box. On 24 Apr 2021, at 1:29 am, Regin Quinoa mailto:sweatr...@gmail.com>> wrote: Hi, I am using pyspark sql to load files into table following ```LOAD DATA LOCAL INPATH

pyspark sql load with path of special character

2021-04-23 Thread Regin Quinoa
Hi, I am using pyspark sql to load files into table following ```LOAD DATA LOCAL INPATH '/user/hive/warehouse/students' OVERWRITE INTO TABLE test_load;``` https://spark.apache.org/docs/latest/sql-ref-syntax-dml-load.html It complains pyspark.sql.utils.AnalysisException: load data input path does