You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2014/02/13 06:28:19 UTC

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

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

Hyunsik Choi commented on TAJO-594:
-----------------------------------

Thank you for your bug report. Its main cause is omission of TID column in the table 'TABLES'.

The solution is to recover the following line.
https://github.com/apache/incubator-tajo/commit/eb563addd336019417d045b95277dec9f89b8f5f#diff-94a5e2e2ee7a25af4e1574a06dfbb002L91

> MySQL store doesn't work
> ------------------------
>
>                 Key: TAJO-594
>                 URL: https://issues.apache.org/jira/browse/TAJO-594
>             Project: Tajo
>          Issue Type: Bug
>          Components: catalog
>         Environment: mysql-connector-java-5.1.28.jar
>            Reporter: Yongjun Park
>            Priority: Blocker
>             Fix For: 0.8-incubating
>
>
> 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)