lundi 7 avril 2014

la ruche - ajout d'un commentaire à une colonne de partition - Stack Overflow


I have the following hive table, where eventdate is the partition column:


hive> describe item_pages;
siteid int the site identifier for the host domain
externalsessionid string the instrumented sessionid
item_pages array<string> an array of all distinct page IDs
eventdate string None

# Partition Information
# col_name data_type comment

eventdate string None

Is there a way that I can add a comment to the table metadata for the partition column? I get the following response when treating the eventdate partition column as a regular column:


hive> ALTER TABLE da_itempages CHANGE eventdate eventdate string COMMENT 'the PST calendar date of the item page views in YYYY-MM-DD format'
Column 'eventdate' does not exists
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

(the example command is the exact same command the successfully inserted comments into the columns that have columns per the describe statement.)



I have the following hive table, where eventdate is the partition column:


hive> describe item_pages;
siteid int the site identifier for the host domain
externalsessionid string the instrumented sessionid
item_pages array<string> an array of all distinct page IDs
eventdate string None

# Partition Information
# col_name data_type comment

eventdate string None

Is there a way that I can add a comment to the table metadata for the partition column? I get the following response when treating the eventdate partition column as a regular column:


hive> ALTER TABLE da_itempages CHANGE eventdate eventdate string COMMENT 'the PST calendar date of the item page views in YYYY-MM-DD format'
Column 'eventdate' does not exists
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

(the example command is the exact same command the successfully inserted comments into the columns that have columns per the describe statement.)


0 commentaires:

Enregistrer un commentaire