https://community.cloudera.com/t5/Archives-of-Support-Questions/Unable-to-create-a-table-in-hive/m-p/212688#M84387 <P>CREATE TABLE IF NOT EXISTS employee (eid int, name String,<BR />salary String)<BR />ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘\t’<BR />LINES TERMINATED BY ‘\n’<BR />STORED AS TEXTFILE;</P><P>I'm getting the below error:</P><P>MismatchedTokenException(26!=298)<BR /> at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617)<BR /> at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormatFieldIdentifier(HiveParser.java:31777)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.rowFormatDelimited(HiveParser.java:30730)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormat(HiveParser.java:31006)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:4677)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:2138)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1392)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1030)<BR /> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:199)<BR /> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)<BR /> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:417)<BR /> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)<BR /> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1026)<BR /> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1091)<BR /> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:962)<BR /> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:952)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431)<BR /> at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:800)<BR /> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694)<BR /> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:498)<BR /> at org.apache.hadoop.util.RunJar.main(RunJar.java:212)<BR />FAILED: ParseException line 3:44 mismatched input 't' expecting StringLiteral near 'BY' in table row format's field separator</P><P>Even iIf I use '\073' , I'm getting the error:</P><P>MismatchedTokenException(287!=298)<BR /> at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617)<BR /> at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormatFieldIdentifier(HiveParser.java:31777)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.rowFormatDelimited(HiveParser.java:30730)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormat(HiveParser.java:31006)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:4677)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:2138)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1392)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1030)<BR /> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:199)<BR /> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)<BR /> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:417)<BR /> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)<BR /> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1026)<BR /> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1091)<BR /> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:962)<BR /> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:952)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431)<BR /> at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:800)<BR /> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694)<BR /> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:498)<BR /> at org.apache.hadoop.util.RunJar.main(RunJar.java:212)<BR />FAILED: ParseException line 3:44 mismatched input '073' expecting StringLiteral near 'BY' in table row format's field separator</P><P>Please let me know how to fix this.</P> Wed, 17 Oct 2018 11:32:22 GMT sivasai2006 2018-10-17T11:32:22Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Unable-to-create-a-table-in-hive/m-p/212688#M84387 <P>CREATE TABLE IF NOT EXISTS employee (eid int, name String,<BR />salary String)<BR />ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘\t’<BR />LINES TERMINATED BY ‘\n’<BR />STORED AS TEXTFILE;</P><P>I'm getting the below error:</P><P>MismatchedTokenException(26!=298)<BR /> at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617)<BR /> at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormatFieldIdentifier(HiveParser.java:31777)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.rowFormatDelimited(HiveParser.java:30730)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormat(HiveParser.java:31006)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:4677)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:2138)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1392)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1030)<BR /> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:199)<BR /> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)<BR /> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:417)<BR /> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)<BR /> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1026)<BR /> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1091)<BR /> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:962)<BR /> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:952)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431)<BR /> at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:800)<BR /> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694)<BR /> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:498)<BR /> at org.apache.hadoop.util.RunJar.main(RunJar.java:212)<BR />FAILED: ParseException line 3:44 mismatched input 't' expecting StringLiteral near 'BY' in table row format's field separator</P><P>Even iIf I use '\073' , I'm getting the error:</P><P>MismatchedTokenException(287!=298)<BR /> at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617)<BR /> at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormatFieldIdentifier(HiveParser.java:31777)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.rowFormatDelimited(HiveParser.java:30730)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormat(HiveParser.java:31006)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:4677)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:2138)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1392)<BR /> at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1030)<BR /> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:199)<BR /> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)<BR /> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:417)<BR /> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)<BR /> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1026)<BR /> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1091)<BR /> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:962)<BR /> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:952)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221)<BR /> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431)<BR /> at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:800)<BR /> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694)<BR /> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR /> at java.lang.reflect.Method.invoke(Method.java:498)<BR /> at org.apache.hadoop.util.RunJar.main(RunJar.java:212)<BR />FAILED: ParseException line 3:44 mismatched input '073' expecting StringLiteral near 'BY' in table row format's field separator</P><P>Please let me know how to fix this.</P> Wed, 17 Oct 2018 11:32:22 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Unable-to-create-a-table-in-hive/m-p/212688#M84387 sivasai2006 2018-10-17T11:32:22Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Unable-to-create-a-table-in-hive/m-p/212689#M84388 <P> <A rel="user" href="https://community.cloudera.com/users/97233/sivasai2006.html" nodeid="97233">@Sivakumar Mahalingam</A>,</P><P>I guess the problem is with quotes. use ' instead of ’ </P> Wed, 17 Oct 2018 11:47:57 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Unable-to-create-a-table-in-hive/m-p/212689#M84388 asirna 2018-10-17T11:47:57Z