[
https://issues.apache.org/jira/browse/SPARK-40062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17579217#comment-17579217
]
zzzzming95 commented on SPARK-40062:
------------------------------------
I can't reproduce the problem.
Can you give the specific operations to reproduce, such as how to write to the
partition.
> Spark - Creating Sub Folder while writing to Partitioned Hive Table
> -------------------------------------------------------------------
>
> Key: SPARK-40062
> URL: https://issues.apache.org/jira/browse/SPARK-40062
> Project: Spark
> Issue Type: Bug
> Components: Spark Submit
> Affects Versions: 2.4.7
> Reporter: dinesh sachdev
> Priority: Minor
>
> We had been writing to a Partitioned Hive Table and realized that data is
> being written has sub-folder.
> For ex- Refer Table definition as below -
> _Create table T1 ( name string, address string) Partitioned by (process_date
> string) stored as parquet location '/mytable/a/b/c/org=employee';_
>
> While writing to table HDFS path being written looks something like this -
> {_}/mytable/a/b/c/org=employee/{_}{_}process_date=20220812/{_}{color:#de350b}_org=employee_{color}
>
> The unnecessary addition of _org=employee_ after process_date partition is
> because Hive Table has location consisting "=" operator, which Hive uses as
> syntax to determine partition column.
> Re-defining Table resolves above problem -
> _Create table T1 ( name string, address string) Partitioned by (process_date
> string) stored as parquet location '/mytable/a/b/c/employee';_
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
