[
https://issues.apache.org/jira/browse/HIVE-1501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12925618#action_12925618
]
He Yongqiang commented on HIVE-1501:
------------------------------------
String indexCols = MetaStoreUtils.getColumnNamesFromFieldSchema(indexField);
indexCols is a column list, like:
col1, col2,col3
After the change, it should be `col1`, `col2`, `col3`...
So the whole command should be like:
INSERT OVERWRITE TABLE `table_name`
PARTITION (...)
SELECT `col1`, `col2`, `col3`..., `INPUT__FILE__NAME`, collect_set
(`BLOCK__OFFSET__INSIDE__FILE`)
FROM `base_table`
...
GROUP BY `col1`, `col2`, `col3`..., `INPUT__FILE__NAME`
> when generating reentrant INSERT for index rebuild, quote identifiers using
> backticks
> -------------------------------------------------------------------------------------
>
> Key: HIVE-1501
> URL: https://issues.apache.org/jira/browse/HIVE-1501
> Project: Hive
> Issue Type: Bug
> Components: Indexing
> Affects Versions: 0.7.0
> Reporter: John Sichi
> Assignee: Skye Berghel
> Fix For: 0.7.0
>
> Attachments: 1501.patch, 1501_with_tests.patch
>
>
> Yongqiang, you mentioned that you weren't able to do this due to SORT BY not
> accepting them. The SORT BY is gone now as of HIVE-1494 (and SORT BY needs
> to be fixed anyway).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
