Re: Query parsing error for the join query between different database

Thanks Herman, I didn't recognise the "user" is reserved word. it works now. On 19 May 2016 at 08:02, Herman van Hövell tot Westerflier < hvanhov...@questtec.nl> wrote: > 'User' is a SQL2003 keyword. This is normally not a problem, except when > you use it as a table alias (which you are doing).

Re: Query parsing error for the join query between different database

'User' is a SQL2003 keyword. This is normally not a problem, except when you use it as a table alias (which you are doing). Change the alias or place it between backticks and you should be fine. 2016-05-18 23:51 GMT+02:00 JaeSung Jun : > It's spark 1.6.1 and hive 1.2.1

Re: Query parsing error for the join query between different database

It's spark 1.6.1 and hive 1.2.1 (spark-sql saying "SET spark.sql.hive.version=1.2.1"). Thanks On 18 May 2016 at 23:31, Ted Yu wrote: > Which release of Spark / Hive are you using ? > > Cheers > > On May 18, 2016, at 6:12 AM, JaeSung Jun wrote: > > Hi, >

Re: Query parsing error for the join query between different database

Which release of Spark / Hive are you using ? Cheers > On May 18, 2016, at 6:12 AM, JaeSung Jun wrote: > > Hi, > > I'm working on custom data source provider, and i'm using fully qualified > table name in FROM clause like following : > > SELECT user. uid, dept.name > FROM

Query parsing error for the join query between different database

Hi, I'm working on custom data source provider, and i'm using fully qualified table name in FROM clause like following : SELECT user. uid, dept.name FROM userdb.user user, deptdb.dept WHERE user.dept_id = dept.id and i've got the following error : MismatchedTokenException(279!=26) at