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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
