hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dean Zhu (JIRA)" <j...@apache.org>
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
                 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

Mime
View raw message