[
https://issues.apache.org/jira/browse/HIVE-1803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12991563#comment-12991563
]
John Sichi commented on HIVE-1803:
----------------------------------
I tried it, and I did get that error, but not in the REBUILD, which worked
fine. So you may be misreading the output.
The error I'm getting is
{noformat}
FAILED: Error in semantic analysis: line 2:65 Expression Not In Group By Key
`_bucketname`
{noformat}
This error is correct since the statement below has `_bucketname` in the SELECT
list but not in the GROUP BY.
{noformat}
INSERT OVERWRITE DIRECTORY "/tmp/index_test_index_result" SELECT `_bucketname`,
COLLECT_BITMAP_SET(`_offset`, `_bitmaps`) as `_offsets` FROM
default__srcpart_srcpart_index_proj__ x WHERE x.key=100 AND x.ds = '2008-04-08'
GROUP BY x.key, x.ds;
{noformat}
As a result, the test bails out in the middle (without doing any of its DROP
INDEX cleanup). After that, what happens is that the test framework tries to
clean up by dropping all existing tables, but it isn't smart enough to know
that it shouldn't try to drop index tables directly. (We could use a separate
patch for that.)
{noformat}
[junit] org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.RuntimeException: The table default__srcpart_srcpart_index_proj__ is
an index table. Please do drop index instead.
[junit] at
org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:739)
[junit] at
org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:716)
[junit] at
org.apache.hadoop.hive.ql.QTestUtil.clearTestSideEffects(QTestUtil.java:333)
[junit] at
org.apache.hadoop.hive.cli.TestCliDriver.setUp(TestCliDriver.java:55)
[junit] at junit.framework.TestCase.runBare(TestCase.java:125)
...
{noformat}
> Implement bitmap indexing in Hive
> ---------------------------------
>
> Key: HIVE-1803
> URL: https://issues.apache.org/jira/browse/HIVE-1803
> Project: Hive
> Issue Type: New Feature
> Reporter: Marquis Wang
> Assignee: Marquis Wang
> Attachments: HIVE-1803.1.patch, HIVE-1803.2.patch,
> bitmap_index_1.png, bitmap_index_2.png
>
>
> Implement bitmap index handler to complement compact indexing.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
