On Tue, May 31, 2016 at 1:02 PM, ayan guha <guha.a...@gmail.com> wrote:
> Hi
>
> While running spark thrift, we are getting 2 issues.
>
> 1.. 16/05/31 14:36:18 WARN ThriftCLIService: Error executing statement:
> org.apache.hive.service.cli.HiveSQLException:
> org.apache.spark.sql.AnalysisException: Table not found:
> sds.unhealthy_om_delta;
>
Are you using *;* (semi colon) at the end of query like
*sqlcontext.sql(query;)*? You should not mention *;* at the end of query
at
> org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.org
> $apache$spark$sql$hive$thriftserver$SparkExecuteStatementOperation$$execute(SparkExecuteStatementOperation.scala:
> 246)
>
> Unfortunately, the table exists and I can see it from beeline.
>
> This error is happening from a front end, where the front end service is
> launched by a different user. However, we do not restrict read access to
> anybody.
>
> 2. org.apache.hive.service.cli.HiveSQLException:
> java.lang.RuntimeException: [1.20] failure: end of input expected
>
> SHOW TABLES IN sds LIKE '.*'
> ^
> at
> org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.org
> $apache$spark$sql$hive$thriftserver$SparkExecuteStatementOperation$$execute(SparkExecuteStatementOperation.scala:
> 246)
>
> It seems a pure Hive error, and looks like wrong syntax.. Any suggestion
> what is the correct syntax?
>
> Both issues are coming while running a 3rd party tool (datameer)
> connecting to Spark Thrift Server. Spark Version 1.6 on HDP 2.4.
>
>
> TIA...
>
> --
> Best Regards,
> Ayan Guha
>
--
Thanks,
Raju Bairishetti,
www.lazada.com
