You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@lens.apache.org by "Jaideep Dhok (JIRA)" <ji...@apache.org> on 2015/02/25 07:13:05 UTC

[jira] [Commented] (LENS-307) Queries on native tables should pickup current db

    [ https://issues.apache.org/jira/browse/LENS-307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14336072#comment-14336072 ] 

Jaideep Dhok commented on LENS-307:
-----------------------------------

This is because changing database should also change the database in underlying hive session, which we are not doing currently.

In case of cube queries this is being handled by prefixing table names with DB names.

Current workaround is to use fully qualified names for native tables.

> Queries on native tables should pickup current db
> -------------------------------------------------
>
>                 Key: LENS-307
>                 URL: https://issues.apache.org/jira/browse/LENS-307
>             Project: Apache Lens
>          Issue Type: Bug
>            Reporter: Arshad Matin
>
> {noformat}
> lens-shell>use lensstats
> Successfully switched to lensstats
> lens-shell>query execute show partitions queryexecutionstatistics
> Launching query failed cause:Error while compiling statement: FAILED: SemanticException [Error 10001]: Table not found queryexecutionstatistics
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)