Re: Release data for spark 1.6?
thanks Sean and Ted, I will wait for 1.6 to be out. Happy Christmas to all ! Thanks Sri On Sat, Dec 12, 2015 at 12:18 PM, Ted Yu wrote: > Please take a look at SPARK-9078 which allows jdbc dialects to override > the query for checking table existence. > > On Dec 12, 2015, at 7:12 PM, sri hari kali charan Tummala < > kali.tumm...@gmail.com> wrote: > > Hi Michael, Ted, > > > https://github.com/apache/spark/blob/branch-1.5/sql/core/src/main/scala/org/apache/spark/sql/execution/datasources/jdbc/JdbcUtils.scala#L48 > > In Present spark version in line 48 there is a bug, to check whether table > exists in a database using limit doesnt work for all databases sql server > for example. > > best way to check whehter table exists in any database is to use, select * > from table where 1=2; or select 1 from table where 1=2; this supports all > the databases. > > In spark 1.6 can this change be implemented, this lets > write.mode("append") bug to go away. > > > > def tableExists(conn: Connection, table: String): Boolean = { // Somewhat > hacky, but there isn't a good way to identify whether a table exists for all > // > SQL database systems, considering "table" could also include the database > name. Try(conn.prepareStatement(s"SELECT 1 FROM $table LIMIT 1" > ).executeQuery().next()).isSuccess } > > Solution:- > def tableExists(conn: Connection, table: String): Boolean = { // Somewhat > hacky, but there isn't a good way to identify whether a table exists for all > // > SQL database systems, considering "table" could also include the database > name. Try(conn.prepareStatement(s"SELECT 1 FROM $table where 1=2" > ).executeQuery().next()).isSuccess } > > > > Thanks > Sri > > > > On Wed, Dec 9, 2015 at 10:30 PM, Michael Armbrust > wrote: > >> The release date is "as soon as possible". In order to make an Apache >> release we must present a release candidate and have 72-hours of voting by >> the PMC. As soon as there are no known bugs, the vote will pass and 1.6 >> will be released. >> >> In the mean time, I'd love support from the community testing the most >> recent release candidate. >> >> On Wed, Dec 9, 2015 at 2:19 PM, Sri wrote: >> >>> Hi Ted, >>> >>> Thanks for the info , but there is no particular release date from my >>> understanding the package is in testing there is no release date mentioned. >>> >>> Thanks >>> Sri >>> >>> >>> >>> Sent from my iPhone >>> >>> > On 9 Dec 2015, at 21:38, Ted Yu wrote: >>> > >>> > See this thread: >>> > >>> > >>> http://search-hadoop.com/m/q3RTtBMZpK7lEFB1/Spark+1.6.0+RC&subj=Re+VOTE+Release+Apache+Spark+1+6+0+RC1+ >>> > >>> >> On Dec 9, 2015, at 1:20 PM, "kali.tumm...@gmail.com" < >>> kali.tumm...@gmail.com> wrote: >>> >> >>> >> Hi All, >>> >> >>> >> does anyone know exact release data for spark 1.6 ? >>> >> >>> >> Thanks >>> >> Sri >>> >> >>> >> >>> >> >>> >> -- >>> >> View this message in context: >>> http://apache-spark-user-list.1001560.n3.nabble.com/Release-data-for-spark-1-6-tp25654.html >>> >> Sent from the Apache Spark User List mailing list archive at >>> Nabble.com <http://nabble.com>. >>> >> >>> >> - >>> >> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org >>> >> For additional commands, e-mail: user-h...@spark.apache.org >>> >> >>> >>> - >>> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org >>> For additional commands, e-mail: user-h...@spark.apache.org >>> >>> >> > > > -- > Thanks & Regards > Sri Tummala > > -- Thanks & Regards Sri Tummala
Re: Release data for spark 1.6?
Please take a look at SPARK-9078 which allows jdbc dialects to override the query for checking table existence. > On Dec 12, 2015, at 7:12 PM, sri hari kali charan Tummala > wrote: > > Hi Michael, Ted, > > https://github.com/apache/spark/blob/branch-1.5/sql/core/src/main/scala/org/apache/spark/sql/execution/datasources/jdbc/JdbcUtils.scala#L48 > > In Present spark version in line 48 there is a bug, to check whether table > exists in a database using limit doesnt work for all databases sql server for > example. > > best way to check whehter table exists in any database is to use, select * > from table where 1=2; or select 1 from table where 1=2; this supports all > the databases. > > In spark 1.6 can this change be implemented, this lets write.mode("append") > bug to go away. > > > > def tableExists(conn: Connection, table: String): Boolean = { > > // Somewhat hacky, but there isn't a good way to identify whether a table > exists for all > // SQL database systems, considering "table" could also include the > database name. > Try(conn.prepareStatement(s"SELECT 1 FROM $table LIMIT > 1").executeQuery().next()).isSuccess > } > > Solution:- > def tableExists(conn: Connection, table: String): Boolean = { > > // Somewhat hacky, but there isn't a good way to identify whether a table > exists for all > // SQL database systems, considering "table" could also include the > database name. > Try(conn.prepareStatement(s"SELECT 1 FROM $table where > 1=2").executeQuery().next()).isSuccess > } > > > > Thanks > Sri > > > >> On Wed, Dec 9, 2015 at 10:30 PM, Michael Armbrust >> wrote: >> The release date is "as soon as possible". In order to make an Apache >> release we must present a release candidate and have 72-hours of voting by >> the PMC. As soon as there are no known bugs, the vote will pass and 1.6 >> will be released. >> >> In the mean time, I'd love support from the community testing the most >> recent release candidate. >> >>> On Wed, Dec 9, 2015 at 2:19 PM, Sri wrote: >>> Hi Ted, >>> >>> Thanks for the info , but there is no particular release date from my >>> understanding the package is in testing there is no release date mentioned. >>> >>> Thanks >>> Sri >>> >>> >>> >>> Sent from my iPhone >>> >>> > On 9 Dec 2015, at 21:38, Ted Yu wrote: >>> > >>> > See this thread: >>> > >>> > http://search-hadoop.com/m/q3RTtBMZpK7lEFB1/Spark+1.6.0+RC&subj=Re+VOTE+Release+Apache+Spark+1+6+0+RC1+ >>> > >>> >> On Dec 9, 2015, at 1:20 PM, "kali.tumm...@gmail.com" >>> >> wrote: >>> >> >>> >> Hi All, >>> >> >>> >> does anyone know exact release data for spark 1.6 ? >>> >> >>> >> Thanks >>> >> Sri >>> >> >>> >> >>> >> >>> >> -- >>> >> View this message in context: >>> >> http://apache-spark-user-list.1001560.n3.nabble.com/Release-data-for-spark-1-6-tp25654.html >>> >> Sent from the Apache Spark User List mailing list archive at Nabble.com. >>> >> >>> >> - >>> >> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org >>> >> For additional commands, e-mail: user-h...@spark.apache.org >>> >> >>> >>> - >>> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org >>> For additional commands, e-mail: user-h...@spark.apache.org > > > > -- > Thanks & Regards > Sri Tummala >
Re: Release data for spark 1.6?
Hi Michael, Ted, https://github.com/apache/spark/blob/branch-1.5/sql/core/src/main/scala/org/apache/spark/sql/execution/datasources/jdbc/JdbcUtils.scala#L48 In Present spark version in line 48 there is a bug, to check whether table exists in a database using limit doesnt work for all databases sql server for example. best way to check whehter table exists in any database is to use, select * from table where 1=2; or select 1 from table where 1=2; this supports all the databases. In spark 1.6 can this change be implemented, this lets write.mode("append") bug to go away. def tableExists(conn: Connection, table: String): Boolean = { // Somewhat hacky, but there isn't a good way to identify whether a table exists for all // SQL database systems, considering "table" could also include the database name. Try(conn.prepareStatement(s"SELECT 1 FROM $table LIMIT 1" ).executeQuery().next()).isSuccess } Solution:- def tableExists(conn: Connection, table: String): Boolean = { // Somewhat hacky, but there isn't a good way to identify whether a table exists for all // SQL database systems, considering "table" could also include the database name. Try(conn.prepareStatement(s"SELECT 1 FROM $table where 1=2" ).executeQuery().next()).isSuccess } Thanks Sri On Wed, Dec 9, 2015 at 10:30 PM, Michael Armbrust wrote: > The release date is "as soon as possible". In order to make an Apache > release we must present a release candidate and have 72-hours of voting by > the PMC. As soon as there are no known bugs, the vote will pass and 1.6 > will be released. > > In the mean time, I'd love support from the community testing the most > recent release candidate. > > On Wed, Dec 9, 2015 at 2:19 PM, Sri wrote: > >> Hi Ted, >> >> Thanks for the info , but there is no particular release date from my >> understanding the package is in testing there is no release date mentioned. >> >> Thanks >> Sri >> >> >> >> Sent from my iPhone >> >> > On 9 Dec 2015, at 21:38, Ted Yu wrote: >> > >> > See this thread: >> > >> > >> http://search-hadoop.com/m/q3RTtBMZpK7lEFB1/Spark+1.6.0+RC&subj=Re+VOTE+Release+Apache+Spark+1+6+0+RC1+ >> > >> >> On Dec 9, 2015, at 1:20 PM, "kali.tumm...@gmail.com" < >> kali.tumm...@gmail.com> wrote: >> >> >> >> Hi All, >> >> >> >> does anyone know exact release data for spark 1.6 ? >> >> >> >> Thanks >> >> Sri >> >> >> >> >> >> >> >> -- >> >> View this message in context: >> http://apache-spark-user-list.1001560.n3.nabble.com/Release-data-for-spark-1-6-tp25654.html >> >> Sent from the Apache Spark User List mailing list archive at >> Nabble.com. >> >> >> >> - >> >> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org >> >> For additional commands, e-mail: user-h...@spark.apache.org >> >> >> >> - >> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org >> For additional commands, e-mail: user-h...@spark.apache.org >> >> > -- Thanks & Regards Sri Tummala
Re: Release data for spark 1.6?
The release date is "as soon as possible". In order to make an Apache release we must present a release candidate and have 72-hours of voting by the PMC. As soon as there are no known bugs, the vote will pass and 1.6 will be released. In the mean time, I'd love support from the community testing the most recent release candidate. On Wed, Dec 9, 2015 at 2:19 PM, Sri wrote: > Hi Ted, > > Thanks for the info , but there is no particular release date from my > understanding the package is in testing there is no release date mentioned. > > Thanks > Sri > > > > Sent from my iPhone > > > On 9 Dec 2015, at 21:38, Ted Yu wrote: > > > > See this thread: > > > > > http://search-hadoop.com/m/q3RTtBMZpK7lEFB1/Spark+1.6.0+RC&subj=Re+VOTE+Release+Apache+Spark+1+6+0+RC1+ > > > >> On Dec 9, 2015, at 1:20 PM, "kali.tumm...@gmail.com" < > kali.tumm...@gmail.com> wrote: > >> > >> Hi All, > >> > >> does anyone know exact release data for spark 1.6 ? > >> > >> Thanks > >> Sri > >> > >> > >> > >> -- > >> View this message in context: > http://apache-spark-user-list.1001560.n3.nabble.com/Release-data-for-spark-1-6-tp25654.html > >> Sent from the Apache Spark User List mailing list archive at Nabble.com. > >> > >> - > >> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org > >> For additional commands, e-mail: user-h...@spark.apache.org > >> > > - > To unsubscribe, e-mail: user-unsubscr...@spark.apache.org > For additional commands, e-mail: user-h...@spark.apache.org > >
Re: Release data for spark 1.6?
Hi Ted, Thanks for the info , but there is no particular release date from my understanding the package is in testing there is no release date mentioned. Thanks Sri Sent from my iPhone > On 9 Dec 2015, at 21:38, Ted Yu wrote: > > See this thread: > > http://search-hadoop.com/m/q3RTtBMZpK7lEFB1/Spark+1.6.0+RC&subj=Re+VOTE+Release+Apache+Spark+1+6+0+RC1+ > >> On Dec 9, 2015, at 1:20 PM, "kali.tumm...@gmail.com" >> wrote: >> >> Hi All, >> >> does anyone know exact release data for spark 1.6 ? >> >> Thanks >> Sri >> >> >> >> -- >> View this message in context: >> http://apache-spark-user-list.1001560.n3.nabble.com/Release-data-for-spark-1-6-tp25654.html >> Sent from the Apache Spark User List mailing list archive at Nabble.com. >> >> - >> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org >> For additional commands, e-mail: user-h...@spark.apache.org >> - To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org
Re: Release data for spark 1.6?
See this thread: http://search-hadoop.com/m/q3RTtBMZpK7lEFB1/Spark+1.6.0+RC&subj=Re+VOTE+Release+Apache+Spark+1+6+0+RC1+ > On Dec 9, 2015, at 1:20 PM, "kali.tumm...@gmail.com" > wrote: > > Hi All, > > does anyone know exact release data for spark 1.6 ? > > Thanks > Sri > > > > -- > View this message in context: > http://apache-spark-user-list.1001560.n3.nabble.com/Release-data-for-spark-1-6-tp25654.html > Sent from the Apache Spark User List mailing list archive at Nabble.com. > > - > To unsubscribe, e-mail: user-unsubscr...@spark.apache.org > For additional commands, e-mail: user-h...@spark.apache.org > - To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org
Release data for spark 1.6?
Hi All, does anyone know exact release data for spark 1.6 ? Thanks Sri -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Release-data-for-spark-1-6-tp25654.html Sent from the Apache Spark User List mailing list archive at Nabble.com. - To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org