[
https://issues.apache.org/jira/browse/SPARK-18930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15786368#comment-15786368
]
Egor Pahomov commented on SPARK-18930:
--------------------------------------
I'm not sure, that such restriction buried in documentation is OK. Basically
the problem - I've created correct schema for table. I've correctly inserted
into it. But for some reason I need to keep order of columns in select statement
> Inserting in partitioned table - partitioned field should be last in select
> statement.
> ---------------------------------------------------------------------------------------
>
> Key: SPARK-18930
> URL: https://issues.apache.org/jira/browse/SPARK-18930
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.2
> Reporter: Egor Pahomov
>
> CREATE TABLE temp.test_partitioning_4 (
> num string
> )
> PARTITIONED BY (
> day string)
> stored as parquet
> INSERT INTO TABLE temp.test_partitioning_4 PARTITION (day)
> select day, count(*) as num from
> hss.session where year=2016 and month=4
> group by day
> Resulted schema on HDFS: /temp.db/test_partitioning_3/day=62456298,
> emp.db/test_partitioning_3/day=69094345....
> As you can imagine these numbers are num of records. But! When I do select *
> from temp.test_partitioning_4 data is correct.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
