Re: Spark SQL -- more than two tables for join

2014-10-07 Thread Matei Zaharia
that sparksql doesn't support > several joins together. > > > > > -- > View this message in context: > http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-more-than-two-tables-for-join-tp13865p15848.html > Sent from the Apache Spark User List mailin

Re: Spark SQL -- more than two tables for join

2014-10-07 Thread Gen
run(Thread.java:745) I use spark 1.1.0, so I have an impression that sparksql doesn't support several joins together. -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-more-than-two-tables-for-join-tp13865p15848.html Sent from the Apache Spa

Re: Spark SQL -- more than two tables for join

2014-10-07 Thread TANG Gen
.run(Thread.java:745) I have an impression that sparksql doesn't support more than two joins -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-more-than-two-tables-for-join-tp13865p15847.html Sent from the Apache Spark User List mail

Re: Re: Spark SQL -- more than two tables for join

2014-09-11 Thread Yin Huai
-- > boyingk...@163.com > > *From:* Michael Armbrust > *Date:* 2014-09-11 00:28 > *To:* arthur.hk.c...@gmail.com > *CC:* arunshell87 ; u...@spark.incubator.apache.org > *Subject:* Re: Spark SQL -- more than two tables for join >What version of Spark SQL are you running

Re: Re: Spark SQL -- more than two tables for join

2014-09-10 Thread boyingk...@163.com
main(SparkSQLHBaseRelation.scala:140) at org.apache.spark.examples.sql.SparkSQLHBaseRelation.main(SparkSQLHBaseRelation.scala) boyingk...@163.com From: Michael Armbrust Date: 2014-09-11 00:28 To: arthur.hk.c...@gmail.com CC: arunshell87; u...@spark.incubator.apache.org Subject: Re: Spark SQL -- more than two tables for join What version of Spark

Re: Spark SQL -- more than two tables for join

2014-09-10 Thread Michael Armbrust
What version of Spark SQL are you running here? I think a lot of your concerns have likely been addressed in more recent versions of the code / documentation. (Spark 1.1 should be published in the next few days) In particular, for serious applications you should use a HiveContext and HiveQL as t

Re: Spark SQL -- more than two tables for join

2014-09-10 Thread arthur.hk.c...@gmail.com
in >> Feb-2015. >> >> I believe you can try HiveQL in Spark for your requirement. >> >> Thanks, >> Arun >> >> >> >> -- >> View this message in context: >> http://apache-spark-user-list.10

Re: Spark SQL -- more than two tables for join

2014-09-10 Thread arthur.hk.c...@gmail.com
requirement. > > Thanks, > Arun > > > > -- > View this message in context: > http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-more-than-two-tables-for-join-tp13865p13877.html > Sent fro

Re: Spark SQL -- more than two tables for join

2014-09-10 Thread arunshell87
Spark for your requirement. Thanks, Arun -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-more-than-two-tables-for-join-tp13865p13877.html Sent from the Apache Spark User List mailing list archive at Nabble.com

Spark SQL -- more than two tables for join

2014-09-10 Thread boyingk...@163.com
Hi: I Hava a question about Spark SQL。 First ,i use left join on two tables,like this: sql("SELECT * FROM youhao_data left join youhao_age on (youhao_data.rowkey=youhao_age.rowkey)").collect().foreach(println) the result is my except。 But,when i use left join on three tables or more ,like this: