[ https://issues.apache.org/jira/browse/HIVE-20146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16540901#comment-16540901 ]
BELUGA BEHR commented on HIVE-20146: ------------------------------------ You have a typo in your statement.... {code} 'serder2' => 'serde2' 'org.apache.hadoop.hive.serder2.OpenCSVSerde' => 'org.apache.hadoop.hive.serde2.OpenCSVSerde' {code} https://cwiki.apache.org/confluence/display/Hive/CSV+Serde > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: > org.apache.hadoop.hive.serder2.OpenCSVSerde > ------------------------------------------------------------------------------------------------------------------------------------------------------ > > Key: HIVE-20146 > URL: https://issues.apache.org/jira/browse/HIVE-20146 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 1.2.2 > Reporter: gavin_shi > Priority: Major > > I am trying to create table in hive, but I am getting the following error > {code:java} > //代码占位符 > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: > org.apache.hadoop.hive.serder2.OpenCSVSerde > {code} > the command that create the table : > {code:java} > //代码占位符 > create table csv_tab(id string,name string) row format serde > 'org.apache.hadoop.hive.serder2.OpenCSVSerde' with > serdeproperties("separatorChar"="\t","quoteChar"="'","escapeChar"="\\") > stored as TEXTFILE; > {code} > hadoop version:2.6.0 > hive version:1.2.2 > please help me. > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)