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! >>>>> >>>> >>>
