Flink SQL query orc table is null

Question

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'；

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

Answer 1

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