[
https://issues.apache.org/jira/browse/GRIFFIN-354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17601272#comment-17601272
]
osmondy.yang commented on GRIFFIN-354:
--------------------------------------
sql 执行该SQL会遇到字段太长的错误， 将 `CONFIG VARCHAR ( 20480 )` 改为 `CONFIG TEXT` 即可
> Table 'quartz.DATACONNECTOR' doesn't exist
> ------------------------------------------
>
> Key: GRIFFIN-354
> URL: https://issues.apache.org/jira/browse/GRIFFIN-354
> Project: Griffin
> Issue Type: Bug
> Components: Measure Module
> Affects Versions: 0.6.0
> Reporter: Kingsley
> Priority: Major
> Labels: 0.6.0
> Attachments: error_info.md
>
>
> when i {color:#FF0000}create a measure{color}, the log dispaly the below
> {color:#FF0000}error information{color}:
>
>
> 2020-12-29 21:44:38.992 ERROR 2997 --- [http-nio-8080-exec-6]
> o.a.c.c.C.[.[.[.[dispatcherServlet] [175] : Servlet.service() for servlet
> [dispatcherServlet] in context with path [] threw exception [Request
> processing failed; nested exception is
> org.springframework.transaction.TransactionSystemException: Could not commit
> JPA transaction; nested exception is javax.persistence.RollbackException:
> Exception [EclipseLink-4002] (Eclipse Persistence Services -
> 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'quartz.DATACONNECTOR' doesn't exist
> Error Code: 1146
> Call: INSERT INTO DATACONNECTOR (ID, CONFIG, CREATEDDATE, DATAFRAMENAME,
> DATATIMEZONE, DATAUNIT, MODIFIEDDATE, NAME, TYPE, VERSION) VALUES (?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?)
> bind => [5, \{"database":"default","table.name":"demo_src"}, 1609249478939,
> null, , 1day, null, source1609250030772, HIVE, 1.2]
> Query: InsertObjectQuery(DataConnector\{name=source1609250030772type=HIVE,
> version='1.2', config={"database":"default","table.name":"demo_src"}})] with
> root cause
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'quartz.DATACONNECTOR' doesn't exist
>
>
> But I can't find the table name in the init_quartz_mysql_innodb.sql
> It's confusing
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
