Member since
09-14-2017
3
Posts
0
Kudos Received
0
Solutions
09-18-2017
08:21 AM
I did it with quotes removed. The other thing of dropping and recreating the table is not a viable option for me since it will remove all the partition information. And then I have to again add all the partitions manually using add partition command.
... View more
09-15-2017
03:30 PM
Alter table on the following external table fails: CREATE EXTERNAL TABLE IF NOT EXISTS MODULES_1 (
`ModuleID` string , `ModuleName` string ,
`ContractType` string ) PARTITIONED BY (
meta_version string,
year string,
month string,
day string) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH SERDEPROPERTIES ( "field.delim"="\t") LOCATION '/tst/raw/comarch/modules/1'tblproperties("skip.header.line.count"="3"); When I try to modify this table using below: Alter table MODULES_1 ADD COLUMNS(`OperationType` string) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Error: type expected at the position 0 of '<derived from deserializer>:<derived from deserializer>:<derived from deserializer>:string' but '<' is found. I tried it with partition specifications: Alter table MODULES_1 PARTITIONS(meta_version,`year`,`month`,`day`) ADD COLUMNS(`OperationType` string) that also fails. Please suggest a workwround
... View more
Labels:
- Labels:
-
Apache Hive
09-15-2017
03:30 PM
Alter table on the following external table fails: CREATE EXTERNAL TABLE IF NOT EXISTS MODULES_1 (
`ModuleID` string , `ModuleName` string ,
`ContractType` string ) PARTITIONED BY (
meta_version string,
year string,
month string,
day string) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH SERDEPROPERTIES ( "field.delim"="\t") LOCATION '/tst/raw/comarch/modules/1'tblproperties("skip.header.line.count"="3"); When I try to modify this table using below: Alter table MODULES_1 ADD COLUMNS(`OperationType` string) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Error: type expected at the position 0 of '<derived from deserializer>:<derived from deserializer>:<derived from deserializer>:string' but '<' is found. I tried it with partition specifications: Alter table MODULES_1 PARTITIONS(meta_version,`year`,`month`,`day`) ADD COLUMNS(`OperationType` string) that also fails. Please suggest a workwround
... View more
Labels:
- Labels:
-
Apache Hive