CloudBase ParseException

8 views
Skip to first unread message

荆超

unread,
Sep 18, 2010, 9:17:29 PM9/18/10
to cloudba...@googlegroups.com
I tried to use UDT and import data from local files, then insert into
MySQL . Encountered:
[com.business.cloudbase.parser.ParseException: Encountered "<EOF>" at
line 1, column 251., Was expecting one of:, <INT_NUM> ...,
<IDENTIFIER> ..., , com.business.cloudbase.parser.ParseException:
Encountered "<EOF>" at line 1, column 251., Was expecting one of:,
<INT_NUM> ..., <IDENTIFIER> ..., , at
com.business.cloudbase.parser.CBParser.generateParseException(CBParser.java:5266),
at com.business.cloudbase.parser.CBParser.jj_consume_token(CBParser.java:5136),
at com.business.cloudbase.parser.CBParser.columnReference(CBParser.java:2533),
at com.business.cloudbase.parser.CBParser.groupByList(CBParser.java:2451),
at com.business.cloudbase.parser.CBParser.query(CBParser.java:1234),
at com.business.cloudbase.parser.CBParser.queryStmt(CBParser.java:1061),
at com.business.cloudbase.parser.CBParser.insertUsingSQL(CBParser.java:1021),
at com.business.cloudbase.parser.CBParser.insertStmt(CBParser.java:959),
at com.business.cloudbase.parser.CBParser.CBStatement(CBParser.java:150),
at com.business.cloudbase.parser.CBParser.parse(CBParser.java:117),
at com.business.cloudbase.net.ClientHandler$CommandExecutor.handleSQL(ClientHandler.java:486),
at com.business.cloudbase.net.ClientHandler$CommandExecutor.run(ClientHandler.java:163)]

Before error happened, CloudBase had successfully parse some files and
I can find records in MySQL. I don't know why CloudBase failed
half-way.
I use my UDT to parse the same files without CloudBase and Hadoop.
There is noting wrong. I think the problem is about CloudBase.

Tarandeep Singh

unread,
Sep 19, 2010, 2:02:11 AM9/19/10
to cloudba...@googlegroups.com
can you give the sql statement that you used for creating udt and import statement.


--
You received this message because you are subscribed to the Google Groups "CloudBase" group.
To post to this group, send email to cloudba...@googlegroups.com.
To unsubscribe from this group, send email to cloudbase-use...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/cloudbase-users?hl=en.


荆超

unread,
Sep 19, 2010, 2:12:18 AM9/19/10
to cloudba...@googlegroups.com
CREATE TABLE $myCloudBaseTableName OF UDT $myUdtName IMPORT DATA FROM
$myDataDir

INSERT INTO $myMysqlTableName@$myDataBaseLink SELECT ... FROM
$myCloudBaseTableName WHERE ...

The UDT has been registered and DATABASE LINK has been created successfully.

Reply all
Reply to author
Forward
0 new messages