Fixed
hive-site.xml from zeppelin conf
<property>
<name>hive.metastore.client.connect.retry.delay</name>
<value>5</value>
</property>
<property>
<name>hive.metastore.client.socket.timeout</name>
<value>1800</value>
</property>
Remove s (postfix).
Now i see this exception
java.lang.NoClassDefFoundError: org/apache/tez/dag/api/SessionNotRunning at
org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:353)
at
org.apache.spark.sql.hive.HiveContext.sessionState$lzycompute(HiveContext.scala:239)
at
org.apache.spark.sql.hive.HiveContext.sessionState(HiveContext.scala:235)
at
org.apache.spark.sql.hive.HiveContext$QueryExecution.<init>(HiveContext.scala:383)
at org.apache.spark.sql.hive.HiveContext.executePlan(HiveContext.scala:89)
at org.apache.spark.sql.hive.HiveContext.executePlan(HiveContext.scala:49)
at org.apache.spark.sql.DataFrame.<init>(DataFrame.scala:131) at
org.apache.spark.sql.DataFrame$.apply(DataFrame.scala:51) at
org.apache.spark.sql.SQLContext.createDataFrame(SQLContext.scala:323)
Questions
1) Load Data table does not specify any interpreter at the beginning. What
is the default one ? (%spark ?)
2) How does hive and later Tez come into picture here as am submitting a
spark job ?
Regards,
Deepak
On Tue, Aug 4, 2015 at 11:29 AM, ÐΞ€ρ@Ҝ (๏̯͡๏) <deepuj...@gmail.com> wrote:
> Load Data Into Table works fine. But
> But the next paragraph
> %sql
> select age, count(1) value
> from bank
> where age < 30
> group by age
> order by age
>
> Fails
> java.lang.NumberFormatException: For input string: "5s" at
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:492) at
> java.lang.Integer.parseInt(Integer.java:527) at
> org.apache.hadoop.conf.Configuration.getInt(Configuration.java:1258)
>
> Even when i change the query to
> select age from bank
> it throws same exception.
>
>
> Any suggestions ?
>
>
> --
> Deepak
>
>
--
Deepak
