I am trying to ingest schema from sql Server to hive .I am getting below error.
Could you please advise?
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe: columns has 47 elements while columns.types has 44 elements!)]
if you are importing the data from the DB the default field delimiter is comma (,), make sure your data is not having any commas if you are using the default delimiter and the same applies to other delimiter's as well.
Thanks @Sindhu and @vekat ... Sindhu I am directly importing tables into hive that is using --hive-import .So I am not defining the ddl for Hive its automatically taken care of . Here is a sqoop import statement