Cloudera Community
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
AMY
user rank
New Contributor

Re: certification cca159 Data Analyst 2020 - exam...

by New Contributor in Support Questions
‎09-28-2020 10:58 AM
‎09-28-2020 10:58 AM
Hi,    I am giving my certification exam nxt week. i had few questions if you don't mind. How did your exam go? what were the trainings/material you went through? was it sufficient?  Any tips for me?         ... View more

Re: PARSER error while trying to create a simple t...

by New Contributor in Support Questions
‎07-25-2020 08:31 PM
‎07-25-2020 08:31 PM
I just could not see it!!:-( Thank you so much. 😊  ... View more

PARSER error while trying to create a simple table...

by New Contributor in Support Questions
‎07-23-2020 11:30 AM
‎07-23-2020 11:30 AM
I tried creating a simple table , i am not sure what the error is.Can some one please help me. CREATE TABLE stocks_eod ( > stockticker STRING, > tradedate INT, > openprice FLOAT, > highprice FLOAT, > lowprice FLOAT, > volume BIGINT > ) ROW FORMAT DELIMTED FIELDS TERMINATED BY ',';   NoViableAltException(232@[]) at org.apache.hadoop.hive.ql.parse.HiveParser.tableRowFormat(HiveParser.java:36025) at org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:6865) at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:4122) at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1786) at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1152) at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:211) at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:171) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:447) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:330) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1233) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1274) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1170) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1160) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:217) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:169) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:380) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:740) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:685) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:233) at org.apache.hadoop.util.RunJar.main(RunJar.java:148) FAILED: ParseException line 8:2 cannot recognize input near 'ROW' 'FORMAT' 'DELIMTED' in table row format specification ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎10-20-2020 02:36 PM
Community Statistics
Member Since ‎07-23-2020 11:24 AM
Last Visited ‎10-20-2020 02:36 PM
Posts 3