Not sure if its a blocker but there might be a minor issue with hive
context, there is also a work around

*Works:*

from pyspark.sql import HiveContext

sqlContext = HiveContext(sc)
df = sqlContext.sql("select * from test.test1")

*Does not Work:*

 df = sqlContext.table("test.test1")

Py4JJavaError: An error occurred while calling o260.table. :
org.apache.spark.sql.catalyst.analysis.NoSuchTableException     at
org.apache.spark.sql.hive.client.ClientInterface$anonfun$getTable$1.apply(ClientInterface.scala:112)
    at 
org.apache.spark.sql.hive.client.ClientInterface$anonfun$getTable$1.apply(ClientInterface.scala:112)
    at scala.Option.getOrElse(Option.scala:120)     at
org.apache.spark.sql.hive.client.ClientInterface$class.getTable(ClientInterface.scala:112)
    at 
org.apache.spark.sql.hive.client.ClientWrapper.getTable(ClientWrapper.scala:58)
    at 
org.apache.spark.sql.hive.HiveMetastoreCatalog.lookupRelation(HiveMetastoreCatalog.scala:227)
    at 
org.apache.spark.sql.hive.HiveContext$anon$2.org$apache$spark$sql$catalyst$analysis$OverrideCatalog$super$lookupRelation(HiveContext.scala:370)
    at 
org.apache.spark.sql.catalyst.analysis.OverrideCatalog$anonfun$lookupRelation$3.apply(Catalog.scala:165)
    at 
org.apache.spark.sql.catalyst.analysis.OverrideCatalog$anonfun$lookupRelation$3.apply(Catalog.scala:165)
    at scala.Option.getOrElse(Option.scala:120)     at
org.apache.spark.sql.catalyst.analysis.OverrideCatalog$class.lookupRelation(Catalog.scala:165)
    at 
org.apache.spark.sql.hive.HiveContext$anon$2.lookupRelation(HiveContext.scala:370)
    at org.apache.spark.sql.SQLContext.table(SQLContext.scala:754)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)     at
py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:231)     at
py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:379)
at py4j.Gateway.invoke(Gateway.java:259)     at
py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:133)
  at py4j.commands.CallCommand.execute(CallCommand.java:79)     at
py4j.GatewayConnection.run(GatewayConnection.java:207)     at
java.lang.Thread.run(Thread.java:745)  (<class
'py4j.protocol.Py4JJavaError'>, Py4JJavaError(u'An error occurred
while calling o260.table.\n', JavaObject id=o262), <traceback object
at 0x2e248c0>)

How ever which i swtich db context it works

*Works:*

 sqlContext.sql("use test")
 df = sqlContext.table("test1")

Bulit on Mac OSX  JDK6for Mapr Distribution and Running on CentOS 7.0 JDK8

make-distribution.sh --tgz -Pmapr4  -Phive -Pnetlib-lgpl -Phive-thriftserver

didn’t have this issue in RC3 and tried it on scala as well.

Thanks
Bobby
​

Reply via email to