Flink SQL query orc table is null

0
votes

Dears All,

I query the hive table on the Flink client, and the returned results are all NULL. This hive table is an ORC table.I don't know why

Flink SQL> select * from table1 where dt='1609739880002'；

enter image description here

Flink SQL> select count(*) from table1 where dt='1609739880002';

enter image description here

1
apache-flinkflink-sql

1 Answers

0
votes

This problem has been resolved. because the fields in the ORC file are inconsistent with the fields in the hive table created.