massdosage commented on pull request #1495:
URL: https://github.com/apache/iceberg/pull/1495#issuecomment-698279480
I did a little bit of testing with this on a distributed Hive cluster.
Results below.
1. Tried to create a table with no location set, got error
`java.lang.IllegalArgumentException: Table location not set` - that looks
correct.
2. Created a table with location set to an HDFS path - this worked and the
location folder was created.
3. "SELECT *" from this table returned no result - as expected.
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.`
5. I then dropped the table - this worked, it was correctly removed from the
metastore and the location folder from HDFS.
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?
----------------------------------------------------------------
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]
