You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Dean Zhu (JIRA)" <ji...@apache.org> on 2013/06/06 09:46:20 UTC
[jira] [Created] (HIVE-4672) Can not replace columns for RegEx
table
Dean Zhu created HIVE-4672:
------------------------------
Summary: Can not replace columns for RegEx table
Key: HIVE-4672
URL: https://issues.apache.org/jira/browse/HIVE-4672
Project: Hive
Issue Type: Bug
Reporter: Dean Zhu
Problem:
Step1, create a RegEx table with the query like this:
create table regex_table (a string, b string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
with serdeproperties ("input.regex"="(.*),(.*)");
Step2, Replace all columns of this table like this:
alter table regex_table replace columns (c string, d string);
Hive returns with error message like this:
Replace columns is not supported for this table. SerDe may be incompatible.
I think the RegEx table is pretty alike to CSV tables (ROW FORMAT DELIMITED) I don't understand why the columns of CSV tables can be replaced while the RegEx tables' can't. At least I hope there could be a way to reset the column list with the regex.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira