Hi All,I am trying to load data from Hive tables using Spark SQL. I am using
spark-shell. Here is what I see:
val trainingDataTable = sql("""SELECT prod.prod_num, demographics.gender,
demographics.birth_year, demographics.income_group FROM prod p JOIN
demographics d ON d.user_id = p.user_id""")
14/07/25 14:18:46 INFO Analyzer: Max iterations (2) reached for batch
MultiInstanceRelations14/07/25 14:18:46 INFO Analyzer: Max iterations (2)
reached for batch CaseInsensitiveAttributeReferencesjava.lang.RuntimeException:
Table Not Found: prod.
I have these tables in hive. I used show tables command to confirm this. Can
someone please let me know how do I make them accessible here?