hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (HIVE-8712) Cross schema query fails when table has index
Date Mon, 10 Nov 2014 04:05:34 GMT

     [ https://issues.apache.org/jira/browse/HIVE-8712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Navis closed HIVE-8712.
-----------------------

> Cross schema query fails when table has index
> ---------------------------------------------
>
>                 Key: HIVE-8712
>                 URL: https://issues.apache.org/jira/browse/HIVE-8712
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>    Affects Versions: 0.13.0
>            Reporter: Bill Oliver
>             Fix For: 0.13.1
>
>
> I have two schemas, default and accesstesting. 
> I create a table in the second schema with an index.
> When I query the table using a WHERE clause from the first schema, the query fails:
> use default;
> drop table salary_hive;
> use accesstesting;
> drop table salary_hive;
> use accesstesting;
> create table salary_hive (idnum int, salary int, startdate timestamp, enddate timestamp,
jobcode char(20));
> create index salary_hive_idnum_index on table salary_hive(idnum) as 'compact' with deferred
rebuild;
> select * from accesstesting.salary_hive where 0=1;
> use default;
> select * from accesstesting.salary_hive where 0=1;
> FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table
not found accesstesting__salary_hive_salary_hive_idnum_index__



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

Mime
View raw message