FAILED: ParseException line 2:13 mismatched input ',' expecting ( near 'char' in primitive type specification 18/02/07 16:25:13 INFO hcat.SqoopHCatUtilities: 18/02/07 16:25:13 ERROR ql.Driver: FAILED: ParseException line 2:13 mismatched input ',' expecting ( near 'char' in primitive type specification
Whereas, hive import used string type and everything worked fine!
I couldn't find any solution or possible clue so any help to resolve the issue would be appreciated. Thank you.
Sqoop is generating those queries when I'm using hive-import/hcatalog so I can't modify it. When using the hive-import sqoop is generating the string types and no issues with that. But when using hcatalog to create tables it is using varchar with no length and is failing to execute!
I found a work around to avoid using hcatalog but that's not the ideal way to implement. Any other thoughts would help!