Hi,
I'm trying to query on hive view using spark and it is giving different
rowcounts when compared to hive.
here is the view definition in hive
create view test_hive_view as
select col1 , col2 from tab1
left join tab2 on tab1.col1 = tab2.col1
left join tab3 on tab1.col1 = tab3.col1
where col1 in ('Processed')
union
select col1 , col2 from tab4
left join tab5 on tab4.col1 = tab5.col1
left join tab6 on tab4.col4 = tab6.col1
where col1 in ('Processed')
I'm doing select count(1) from test_hive_view where col1 = :some_value.
spark and hive are giving me different results.
Spark is giving different results when I query on view only.
Can anyone point me where the issue is . I'm using spark 1.3 , hive 1.1 and
hadoop 2.6
Thanks
Giri
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/Incorrect-results-with-spark-sql-tp24716.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
For additional commands, e-mail: user-h...@spark.apache.org
