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