Hi,
There is no need to install derby in advance.
For the sqoop.log,
[org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:196)]
Can't fetch repository structure version.
Caused by: java.sql.SQLException: Schema 'SQOOP' does not exist
This error is correct. It’s fine. As it’s your first time to start a Sqoop
server, it will generate DB automatically (also log this error) if it does not
exists.
org.apache.sqoop.common.SqoopException: COMMON_0000:Unable to run specified
query - CREATE TABLE "SQOOP"."SQ_INPUT" ("SQI_ID" BIGINT GENERATED ALWAYS AS
IDENTITY (START WITH 1, INCREMENT BY 1) PRIMARY KEY, "SQI_NAME" VARCHAR(64),
"SQI_FORM" BIGINT, "SQI_INDEX" SMALLINT, "SQI_TYPE" VARCHAR(32), "SQI_STRMASK"
BOOLEAN, "SQI_STRLENGTH" SMALLINT, "SQI_ENUMVALS" VARCHAR(100),CONSTRAINT
"SQOOP"."FK_SQI_SQF" FOREIGN KEY ("SQI_FORM") REFERENCES "SQOOP"."SQ_FORM"
("SQF_ID"))
Caused by: java.sql.SQLSyntaxErrorException: Syntax error: BOOLEAN.
This seems to be the root cause. There is “Syntax error: BOOLEAN” when running
generate scripts. Would you run this script using “ij” of derby to see whether
this script runs correctly in your env?
Regards
Richard
From: Lee S [mailto:[email protected]]
Sent: Tuesday, July 14, 2015 10:56 PM
To: [email protected]
Subject: sqoop2-tool verify with exception: The database was created by or
upgraded by version 10.8
Hi all:
I verify the configuration with the exception below:
ERROR XSLAN: Database at /root/lcy/sqoop-1.99.6-bin-hadoop200/repository/db has
an incompatible format with the current version of the software. The database
was created by or upgraded by version 10.8.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.raw.log.LogToFile.readControlFile(Unknown Source)
at org.apache.derby.impl.store.raw.log.LogToFile.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.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(Unknown
Source)
at org.apache.derby.impl.store.raw.RawStore.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)
It seems that db in repository is not created with derby version 10.8 , but I
dont know how to fix it . I've checked that derby jar in WEB-INF/lib is
10.8.2.2.
I'm working with sqoop-1.99.6, any idea?
