After you upgrade Tajo version, you need to backup or restore the catalog too. You can dump the catalog metadata in the previous version into a sql file. Then, you need to restore the catalog from the sql file.
Please refer to this documentation. http://tajo.apache.org/docs/current/backup_and_restore/catalog.html If you don't have any important catalog metadata, you can remove just /tmp/tajo-catalog-${username} directory. If so, Tajo will create new catalog metadata when you starts up the new Tajo binary. Thanks! On Thu, Oct 1, 2015 at 11:10 AM, Odin Guillermo Caudillo Gallegos <[email protected]> wrote: > do i need to configure something extra if i'm keeping both versions of tajo? > It's showing me the following error when i run the 0.11 version: > > 2015-10-01 13:01:07,905 INFO org.apache.tajo.catalog.store.DerbyStore: > Trying to connect database > (jdbc:derby:/tmp/tajo-catalog-root/db;create=true) > 2015-10-01 13:01:08,177 ERROR org.apache.tajo.catalog.CatalogServer: > CatalogServer initialization failed > java.lang.reflect.InvocationTargetException > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > at org.apache.tajo.catalog.CatalogServer.serviceInit(CatalogServer.java:136) > at org.apache.hadoop.service.AbstractService.init(AbstractService.java:163) > at > org.apache.hadoop.service.CompositeService.serviceInit(CompositeService.java:107) > at org.apache.tajo.master.TajoMaster.serviceInit(TajoMaster.java:213) > at org.apache.hadoop.service.AbstractService.init(AbstractService.java:163) > at org.apache.tajo.master.TajoMaster.main(TajoMaster.java:603) > Caused by: org.apache.tajo.exception.MetadataConnectionException: cannot > connect metadata store 'jdbc:derby:/tmp/tajo-catalog-root/db;create=true': > Failed to start database '/tmp/tajo-catalog-root/db' with class loader > sun.misc.Launcher$AppClassLoader@26f44031, see the next exception for > details. > at > org.apache.tajo.catalog.store.AbstractDBStore.<init>(AbstractDBStore.java:166) > at org.apache.tajo.catalog.store.DerbyStore.<init>(DerbyStore.java:46) > ... 10 more > Caused by: java.sql.SQLException: Failed to start database > '/tmp/tajo-catalog-root/db' with class loader > sun.misc.Launcher$AppClassLoader@26f44031, see the next exception for > details. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) > at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown > Source) > at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) > at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) > at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) > at java.sql.DriverManager.getConnection(DriverManager.java:571) > at java.sql.DriverManager.getConnection(DriverManager.java:233) > at > org.apache.tajo.catalog.store.DerbyStore.createConnection(DerbyStore.java:50) > at > org.apache.tajo.catalog.store.AbstractDBStore.<init>(AbstractDBStore.java:163) > ... 11 more > Caused by: ERROR XJ040: Failed to start database '/tmp/tajo-catalog-root/db' > with class loader sun.misc.Launcher$AppClassLoader@26f44031, see the next > exception for details. > at org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown > Source) > ... 24 more > Caused by: ERROR XSAI2: The conglomerate (577) requested does not exist. > at org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) > at org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) > at > org.apache.derby.impl.store.access.btree.index.B2IFactory.readConglomerate(Unknown > Source) > at > org.apache.derby.impl.store.access.CacheableConglomerate.setIdentity(Unknown > Source) > at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown Source) > at > org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown > Source) > at > org.apache.derby.impl.store.access.RAMTransaction.findConglomerate(Unknown > Source) > at > org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown > Source) > at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown > Source) > at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRows(Unknown Source) > at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRow(Unknown Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropSPSDescriptor(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropSPSDescriptor(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropJDBCMetadataSPSes(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetadataSPSes(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DD_Version.handleMinorRevisionChange(Unknown > Source) > at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTables(Unknown > Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown > Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown > Source) > at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown > Source) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown > Source) > at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown > Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown > Source) > at > org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown > Source) > at > org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown > Source) > at > org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown > Source) > at > org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown > Source) > ... 21 more > > > 2015-10-01 12:11 GMT-05:00 Jihoon Son <[email protected]>: >> >> Record data type is also supported from 0.11. >> If your data is a nested json, you should use some functions to retrieve >> nested fields. (The functions to retrieve json fields are listed in our >> document.) >> So, I recommend to use 0.11. >> 2015년 10월 1일 (목) 오후 8:03, Jihoon Son <[email protected]>님이 작성: >>> >>> Hi, which version of tajo are you using? >>> That star notation is newly supported from 0.11. >>> We are currently testing an rc of 0.11, and you can download it at >>> https://dist.apache.org/repos/dist/dev/tajo/tajo-0.11.0-rc0/. >>> >>> Thanks, >>> Jihoon >>> >>> 2015년 10월 1일 (목) 오후 7:50, Odin Guillermo Caudillo Gallegos >>> [email protected]>님이 작성: >>> >>>> Hi , i just tried to create the table like the example on the slide, but >>>> it's giving me an error: >>>> CREATE EXTERNAL TABLE jsonTable (*) USING json Location >>>> 'hdfs://hadoopMaster:9000/InputJson.json'; >>>> ERROR: syntax error at or near '*' >>>> >>>> I'm using the (*) because the json have a tag "Event-Time" so the column >>>> name couldn't be Event-Time >>>> Thanks >>>> >>>> 2015-10-01 10:41 GMT-05:00 Jihoon Son <[email protected]>: >>>>> >>>>> Actually, you don't have to convert your json file. Instead, you can >>>>> create a tajo table for it. >>>>> You have two choices. >>>>> First is defining all the columns. Another choice is using the >>>>> schemaless concept. >>>>> You can see some examples at 36 and 38 pages of this slide. >>>>> >>>>> http://www.slideshare.net/jihoonson/introduction-to-apache-tajo-data-warehouse-for-big-data >>>>> >>>>> Thanks, >>>>> Jihoon >>>>> >>>>> 2015년 10월 2일 (금) 오전 12:22, Odin Guillermo Caudillo Gallegos >>>>> <[email protected]>님이 작성: >>>>>> >>>>>> Hi, is there someway to convert a json file to a tajo table? >>>>>> Thanks! >>>> >>>> >
