Github user Neuw84 commented on the pull request:
https://github.com/apache/spark/pull/8909#issuecomment-169046278
Since upgrading to Spark 1.6 I can´t query temp tables created from
SparkStreaming using Apache Toad.
The relevant Spark Streaming part.
window.foreachRDD((JavaRDD<Row> rdd, Time time) -> {
if (!rdd.isEmpty()) {
HiveContext sqlContext1 =
JavaSQLContextSingleton.getInstance(rdd.context());
if (sqlContext1.isCached("issues_recent")) {
sqlContext1.uncacheTable("issues_recent");
}
DataFrame recentDataFrame =
sqlContext1.createDataFrame(rdd, schema).coalesce(20);
recentDataFrame.registerTempTable("issues_recent");
recentDataFrame.cache();
}
The SQLContext creation part
class JavaSQLContextSingleton {
static private transient HiveContext instance = null;
static public HiveContext getInstance(SparkContext sparkContext) {
if (instance == null) {
instance = new HiveContext(sparkContext);
}
return instance;
}
}
Without using spark streaming doesn´t help with the problem (loading
parque file a registering a temporary table).
I think that this "issue" may be related to this PR (maybe I am wrong and
this is not the correct place to put this).
Any hints?
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
