greptimedb icon indicating copy to clipboard operation
greptimedb copied to clipboard

Interval type can't flush to parquet

Open QuenKar opened this issue 1 year ago • 0 comments

What type of bug is this?

Unexpected error

What subsystems are affected?

Storage Engine

Minimal reproduce step

  1. start database, use mysql client to connect it.
  2. execute the following sql statements.
create table test2(val interval, ts timestamp time index);

insert into test2 values('1 year', 1000);

alter table test2 add column label varchar;

it will show Failed to encode record batch: NYI: Attempting to write an Arrow interval type MonthDayNano to parquet that is not yet implemented

What did you expect to see?

None

What did you see instead?

None

What operating system did you use?

Mac OS X Ventura 13.2 ARM

What version of GreptimeDB did you use?

0.6

Relevant log output and stack trace

2024-01-24T14:59:49.930290Z ERROR servers::mysql::writer: Failed to handle mysql query err=0: Failed to execute query, query: alter table test2 add column label string, at /Users/xxx/rust-project/greptimedb/src/servers/src/query_handler/sql.rs:89:22
1: Table operation error, at src/frontend/src/instance.rs:273:14
2: Failed to execute ddl, at /Users/xxx/rust-project/greptimedb/src/operator/src/statement/ddl.rs:313:14
3: Failed to wait procedure done, at src/common/meta/src/ddl_manager.rs:264:14
4: Failed to execute procedure, at /Users/xxx/rust-project/greptimedb/src/common/procedure/src/watcher.rs:35:43
5: Failed to execute procedure due to external error
6: Failed to operate on datanode: peer-0(), at src/common/meta/src/ddl/utils.rs:30:27
7: External error, at src/frontend/src/instance/standalone.rs:78:14
8: Operation to region server failed, at src/frontend/src/instance/standalone.rs:60:14
9: Execute gRPC request error, at src/datanode/src/region_server.rs:242:14
10: Failed to handle request for region 4440996184064(1034, 0), at src/datanode/src/region_server.rs:479:14
11: Failed to flush region 4440996184064(1034, 0), at src/mito2/src/flush.rs:672:46
12: Failed to write to buffer, at src/mito2/src/sst/parquet/writer.rs:178:10
13: Failed to encode record batch, at src/common/datasource/src/file_format/parquet.rs:152:27
14: NYI("Attempting to write an Arrow interval type MonthDayNano to parquet that is not yet implemented")

QuenKar avatar Jan 25 '24 03:01 QuenKar