Anyone have any idea why when selecting data from a hive table that is transactional (ACID) from Zeppelin it does not return any data.
I've tried this using %sql %pyspark and %spark interpreters.
I can query and receive data from non-transactional ORC tables just fine.
Can you get result if you query it in spark-shell
When I run the same query in the spark-shell also get the same result of no rows. Would this suggest its a problem with spark accessing hive ACID tables?
..I've seen around on the web that "Spark SQL does not support Hive transactions ("ACID")" . All I want to do is select from the table. Is there any way of getting at data stored in these tables from spark?