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).
'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 (spark-sql saying "SET
> s
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,
>
> I'm working on custom data source prov
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 userdb.user user, d
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
org.antlr.