hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dean Zhu (JIRA)" <>
Subject [jira] [Created] (HIVE-4672) Can not replace columns for RegEx table
Date Thu, 06 Jun 2013 07:46:20 GMT
Dean Zhu created HIVE-4672:

             Summary: Can not replace columns for RegEx table
                 Key: HIVE-4672
             Project: Hive
          Issue Type: Bug
            Reporter: Dean Zhu

    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:

View raw message