[jira] [Comment Edited] (TAJO-594) MySQL store doesn't work

["Yongjun Park (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13909976#comment-13909976 ] 

Yongjun Park edited comment on TAJO-594 at 2/24/14 2:19 AM:
------------------------------------------------------------

add a new patch referring to https://reviews.apache.org/r/18180/diff/3/


was (Author: yongjun):
add a new patch.

> MySQL store doesn't work
> ------------------------
>
>                 Key: TAJO-594
>                 URL: https://issues.apache.org/jira/browse/TAJO-594
>             Project: Tajo
>          Issue Type: Bug
>          Components: catalog
>    Affects Versions: 0.8-incubating
>         Environment: mysql-connector-java-5.1.28.jar
>            Reporter: Yongjun Park
>            Assignee: Yongjun Park
>            Priority: Blocker
>             Fix For: 0.8-incubating
>
>         Attachments: TAJO-594.yongjun.140217.patch.txt, TAJO-594.yongjun.140221-2.patch.txt, TAJO-594.yongjun.140221.patch.txt, TAJO-594.yongjun.140224.patch.txt
>
>
> When I test MySQL catalog store instead of Derby, I get an error below. We have to fix it.
> {noformat}
> 2014-02-12 18:27:49,608 ERROR catalog.CatalogServer (CatalogServer.java:addTable(255)) - Unknown column 'TID' in 'field list'
> java.io.IOException: Unknown column 'TID' in 'field list
>     at org.apache.tajo.catalog.store.AbstractDBStore.addTable(AbstractDBStore.java:326)
>     at org.apache.tajo.catalog.CatalogServer$CatalogProtocolHandler.addTable(CatalogServer.java:253)
>     at org.apache.tajo.catalog.AbstractCatalogClient$6.call(AbstractCatalogClient.java:161)
>     at org.apache.tajo.catalog.AbstractCatalogClient$6.call(AbstractCatalogClient.java:158)
>     at org.apache.tajo.rpc.ServerCallable.withRetries(ServerCallable.java:96)
>     at org.apache.tajo.catalog.AbstractCatalogClient.addTable(AbstractCatalogClient.java:158)
>     at org.apache.tajo.master.GlobalEngine.createTableOnPath(GlobalEngine.java:317)
>     at org.apache.tajo.master.GlobalEngine.createTable(GlobalEngine.java:280)
>     at org.apache.tajo.master.GlobalEngine.updateQuery(GlobalEngine.java:221)
>     at org.apache.tajo.master.GlobalEngine.executeQuery(GlobalEngine.java:142)
>     at org.apache.tajo.master.TajoMasterClientService$TajoMasterClientProtocolServiceHandler.submitQuery(TajoMasterClientService.java:158)
>     at org.apache.tajo.ipc.TajoMasterClientProtocol$TajoMasterClientProtocolService$2.callBlockingMethod(TajoMasterClientProtocol.java:289)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)