Search code examples
apache-flinkflink-sql

Flink SQL query orc table is null

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

Solution

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