dongjoon-hyun commented on issue #2041:
URL: https://github.com/apache/iceberg/issues/2041#issuecomment-766527134


   As @HeartSaVioR mentioned, this is not a bug. Instead, it's the standard SQL 
behavior when there is no explicit column list.
   ```
   postgres=# create table t as select 1 a, 2 b;
   SELECT 1
   postgres=# select * from t;
    a | b 
   ---+---
    1 | 2
   (1 row)
   
   postgres=# create table s(b int, a int);
   CREATE TABLE
   postgres=# insert into s (select * from t);
   INSERT 0 1
   postgres=# select * from s;
    b | a 
   ---+---
    1 | 2
   (1 row)
   ```
   
   Apache Spark 3.1.1 will start to support the explicit column list in `INSERT 
INTO` statement.
   - https://issues.apache.org/jira/browse/SPARK-32976
   
   Although Spark 3.1.1 is still RC1 and Iceberg 0.11.0 RC0 is not compatible 
with it yet, I believe this issue will be resolved by Spark 3.1.1 and Iceberg 
0.11.1 combination soon.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to