[GitHub] [iceberg] samredai commented on issue #5243: iceberg + hive4.0

[GitBox <gi...@apache.org>]

samredai commented on issue #5243:
URL: https://github.com/apache/iceberg/issues/5243#issuecomment-1180890296

   @nashiyue this seems to work for me. Here are the commands I ran, including the ones to run the docker image `kgyrtkirk/hive-dev-box:bazaar` to try this out with.
   
   *Start the docker container*
   ```sh
   docker run --rm -p 10000:10000 --name hive4 -e HIVE_VERSION=4.0.0-alpha-1 -e TEZ_VERSION=0.10.1 -v hive-dev-box_work:/work kgyrtkirk/hive-dev-box:bazaar
   ```
   
   *Launch beeline*
   ```sh
   docker exec -it hive4 /bin/bash --login -e safe_bl
   ```
   
   *Create the table*
   ```sql
   create table test ( 
     id bigint, 
     name string ) 
   PARTITIONED BY (dept string ) 
   stored by iceberg;
   ```
   
   *Add the `age` column*
   ```sql
   alter table default.test add columns (age int);
   ```
   
   *Insert a record*
   ```sql
   insert into test values (1, "1", "1", 1);
   ```
   
   *Query the table*
   ```
   select * from test;
   ```
   
   output:
   ```
   +----------+------------+------------+-----------+
   | test.id  | test.name  | test.dept  | test.age  |
   +----------+------------+------------+-----------+
   | 1        | 1          | 1          | 1         |
   +----------+------------+------------+-----------+
   1 row selected (0.158 seconds)
   ```


-- 
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.

To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org