Error ParseException line 1 103 mismatched input t expecting StringLiteral near by in table row format s field separator

Question

Hi,

I got this error while I was trying to create a table in hive shell, I used this command to create the table

This is the error, Can anyone help how to resolve this?

Answer 1

Hey,

The error you have got is showing that in the given command you haven't put the delimited field that is \t in quotes. Try using the same command but this way:

I hope the error wont be there.