[jira] [Commented] (SPARK-7939) Make URL partition recognition return String by default for all partition column types and values
[ https://issues.apache.org/jira/browse/SPARK-7939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14565083#comment-14565083 ] Apache Spark commented on SPARK-7939: - User 'viirya' has created a pull request for this issue: https://github.com/apache/spark/pull/6503 > Make URL partition recognition return String by default for all partition > column types and values > - > > Key: SPARK-7939 > URL: https://issues.apache.org/jira/browse/SPARK-7939 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.4.0 >Reporter: Jianshi Huang > Labels: 1.4.1 > > Imagine the following HDFS paths: > /data/split=00 > /data/split=01 > ... > /data/split=FF > If I have less than or equal to 10 partitions (00, 01, ... 09), currently > partition recognition will treat column 'split' as integer column. > If I have more than 10 partitions, column 'split' will be recognized as > String... > This is very confusing. *So I'm suggesting to treat partition columns as > String by default*, and allow user to specify types if needed. > Another example is date: > /data/date=2015-04-01 => 'date' is String > /data/date=20150401 => 'date' is Int > Jianshi -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-7939) Make URL partition recognition return String by default for all partition column types and values
[ https://issues.apache.org/jira/browse/SPARK-7939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14564412#comment-14564412 ] Jianshi Huang commented on SPARK-7939: -- That would be nice, also consider disabling type inference as default behavior. Jianshi > Make URL partition recognition return String by default for all partition > column types and values > - > > Key: SPARK-7939 > URL: https://issues.apache.org/jira/browse/SPARK-7939 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.4.0 >Reporter: Jianshi Huang > Labels: 1.4.1 > > Imagine the following HDFS paths: > /data/split=00 > /data/split=01 > ... > /data/split=FF > If I have less than or equal to 10 partitions (00, 01, ... 09), currently > partition recognition will treat column 'split' as integer column. > If I have more than 10 partitions, column 'split' will be recognized as > String... > This is very confusing. *So I'm suggesting to treat partition columns as > String by default*, and allow user to specify types if needed. > Another example is date: > /data/date=2015-04-01 => 'date' is String > /data/date=20150401 => 'date' is Int > Jianshi -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-7939) Make URL partition recognition return String by default for all partition column types and values
[
https://issues.apache.org/jira/browse/SPARK-7939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14564330#comment-14564330
]
Cheng Lian commented on SPARK-7939:
---
We can probably provide a data source option to disable partition column type
inference and default to {{StringType}}.
> Make URL partition recognition return String by default for all partition
> column types and values
> -
>
> Key: SPARK-7939
> URL: https://issues.apache.org/jira/browse/SPARK-7939
> Project: Spark
> Issue Type: Bug
> Components: SQL
>Affects Versions: 1.4.0
>Reporter: Jianshi Huang
>
> Imagine the following HDFS paths:
> /data/split=00
> /data/split=01
> ...
> /data/split=FF
> If I have less than or equal to 10 partitions (00, 01, ... 09), currently
> partition recognition will treat column 'split' as integer column.
> If I have more than 10 partitions, column 'split' will be recognized as
> String...
> This is very confusing. *So I'm suggesting to treat partition columns as
> String by default*, and allow user to specify types if needed.
> Another example is date:
> /data/date=2015-04-01 => 'date' is String
> /data/date=20150401 => 'date' is Int
> Jianshi
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
