pvary commented on pull request #1495:
URL: https://github.com/apache/iceberg/pull/1495#issuecomment-698282548
> I did a little bit of testing with this on a distributed Hive cluster.
Results below.
Really appreciate your help here! Thanks!
> 4. I then tried an insert which didn't work, I might have the syntax of
the insert command wrong?
> ` insert into foo.iceberg_customers select
named_struct("customer_id","999","first_name","some first name");`
> `FAILED: SemanticException [Error 10044]: Line 1:12 Cannot insert into
target table because column number/types are different 'iceberg_customers':
Table insclause-0 has 2 columns, but query has 1 columns.`
I would expect this to work (with #1407 also applied)
```sql
insert into foo.iceberg_customers select 999,"some first name";
```
or
```sql
insert into foo.iceberg_customers values(999,"some first name");
```
To be honest, I have never used "named_struct" before 😄
> It might be good to have a HiveRunner test that creates a table, does an
insert and then reads the values back to check that that all works end to end?
That's the plan, but we need the writer code to get in first 😄
----------------------------------------------------------------
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]
