How to read orc transaction hive table in spark?
I am facing issue while reading ORC transactional table through spark I get schema of hive table but not able to read actual data
See complete scenario :
hive> create table default.Hello(id int,name string) clustered by
(id) into 2 buckets STORED AS ORC TBLPROPERTIES
('transactional'='true');
hive> insert into default.hello values(10,'abc');
Now I am trying to access Hive Orc data from Spark sql but it show only schema
>spark.sql("select * from hello").show()
Output: id,name