我正在尝试在Pyspark中读取使用^A(\001)分隔符的csv文件。我已经阅读了下面的链接,并按照链接中提到的方法尝试了相同的方法,结果正常,即我能够读取CSV文件并进一步处理它们。
链接: 如何使用spark-csv解析使用^A (即\001)作为分隔符的csv文件?
工作正常。
(键值对。使用键,我正在访问值)
错误:
链接: 如何使用spark-csv解析使用^A (即\001)作为分隔符的csv文件?
工作正常。
spark.read.option("wholeFile", "true"). \
option("inferSchema", "false"). \
option("header", "true"). \
option("quote", "\""). \
option("multiLine", "true"). \
option("delimiter", "\u0001"). \
csv("path/to/csv/file.csv")
我想从数据库中读取分隔符,而不是硬编码它。以下是我尝试的方法。
update table set field_delimiter= 'field_delimiter=\\u0001'
(键值对。使用键,我正在访问值)
delimiter = config.FIELD_DELIMITER (This will fetch the delimiter from the database)
>>print(delimiter)
\u0001
不工作
spark.read.option("wholeFile", "true"). \
option("inferSchema", "false"). \
option("header", "true"). \
option("quote", "\""). \
option("multiLine", "true"). \
option("delimiter", delimiter). \
csv("path/to/csv/file.csv")
错误:
: java.lang.IllegalArgumentException: Unsupported special character for delimiter: \u0001
at org.apache.spark.sql.execution.datasources.csv.CSVUtils$.toChar(CSVUtils.scala:106)
at org.apache.spark.sql.execution.datasources.csv.CSVOptions.<init>(CSVOptions.scala:83)
at org.apache.spark.sql.execution.datasources.csv.CSVOptions.<init>(CSVOptions.scala:39)
at org.apache.spark.sql.execution.datasources.csv.CSVFileFormat.inferSchema(CSVFileFormat.scala:55)
at org.apache.spark.sql.execution.datasources.DataSource$$anonfun$7.apply(DataSource.scala:178)
at org.apache.spark.sql.execution.datasources.DataSource$$anonfun$7.apply(DataSource.scala:178)
at scala.Option.orElse(Option.scala:289)
at org.apache.spark.sql.execution.datasources.DataSource.getOrInferFileFormatSchema(DataSource.scala:177)
at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:353)
at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:178)
at org.apache.spark.sql.DataFrameReader.csv(DataFrameReader.scala:533)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)
at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
at py4j.Gateway.invoke(Gateway.java:280)
at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)
at py4j.commands.CallCommand.execute(CallCommand.java:79)
at py4j.GatewayConnection.run(GatewayConnection.java:214)
at java.lang.Thread.run(Thread.java:748)
u'\u0001'
的形式存储的吗?既然你要将其存储在变量中,那么这不就是你应该采用的方式吗? - philantrovertdelimiter = config.FIELD_DELIMITER
。 - data_addict