You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@inlong.apache.org by GitBox <gi...@apache.org> on 2022/07/19 07:05:10 UTC
[GitHub] [inlong] z1076398926 opened a new issue, #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
z1076398926 opened a new issue, #5113:
URL: https://github.com/apache/inlong/issues/5113
### What happened
在使用Docker方式部署InLong，首先发现Docker中没有inlong-sort-connectors，创建数据接入时候manager容器报错：找不到/opt/inlong-sort路径，下载inlong二进制包，仅将inlong-sort复制到manager容器的/opt/目录下，然后又报错，找不到/opt/inlong-sort/connectors目录，又单独下载connectors复制到了manager容器，完整目录/opt/inlong-sort/connectors；
然后重新创建数据接入，之前的报错没有了，出现了新的报错，报错如下：
首先我看到的是：Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
我从MySQL、Hive中都没有看到这张DBS在哪里。
我的配置：
我的Hive是用docker启动的，连接都没问题，也可以看到库和表都被创建了出来，hdfs的路径如下：
### What you expected to happen
首先按照官网文档上的Docker安装方式做完之后，并没有提到需要单独下载inlong-sort-connectors（或者说单独下载并复制到容器的方式是错误的，那怎么做才是正确的？）或者说docker部署时候怎么装inlong-sort-connectors；
然后，上面提到的报错如果是表或者视图，应该自动被创建？（或者我使用的方式有问题）
期望获得帮助并解决此问题，流程是按照官方文档上的操作的（尽管官方文档上的图片是比较旧的版本，和现在1.2.0版本根本对不上）
### How to reproduce
使用一个干净的环境，并安装Docker，使用Docker部署Hive（用InLong官网提到的docker部署Hive的链接去启动），然后使用Docker部署InLong（根据官方文档上操作），根据文档上的流程创建数据接入提交审核，审核通过后，可在manager容器的日志里发现报错
### Environment
docker方式启动
### InLong version
1.2.0
### InLong Component
InLong Manager
### Are you willing to submit PR?
- [X] Yes, I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@inlong.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] dockerzhang commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
dockerzhang commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188812714
@z1076398926
after https://github.com/apache/inlong/pull/5125 merged, you do not need to copy sort dist and connectors to containers.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] dockerzhang commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
dockerzhang commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188814792
As for the hive exception, we find the same issue, and another contributor will fix it later.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] dockerzhang commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
dockerzhang commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188905440
@z1076398926 after https://github.com/apache/inlong/pull/5128 merged, you can try if there still is the hive exception
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] dockerzhang closed issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
dockerzhang closed issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
URL: https://github.com/apache/inlong/issues/5113
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] z1076398926 commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
z1076398926 commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188840477
好的~谢谢
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] z1076398926 commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
z1076398926 commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188913379
> @z1076398926 after #5128 merged, you can try if there still is the hive exception
谢谢，但我现在暂时没法测试，因为用了Master之后，出现了新的问题，我已经开了一个新的Issue，并且您已经在那个Issue中回复。
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] github-actions[bot] commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188679359
Thanks a lot for opening your first issue with us! 🧡 We'll get back to you shortly! ⏳
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] z1076398926 commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
z1076398926 commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188711769
> > 一个，我在数据分组然后对那里的问题，选择执行日志，点击执行日志，报错 
> > 查看经理记录，得到以下信息： 
>
> 你好，@z1076398926 此错误已修复，请使用从 master 分支构建的最新图像。
好的，谢谢~我一开始提交的那个问题，是我哪个步骤出了错？已经排查很久了，目前还没找到问题
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] z1076398926 commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
z1076398926 commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188696660
还有个问题，我在数据分组那里，选择执行日志，然后对失败的步骤点击执行，就会报错
查看manager容器日志，得到以下信息：
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] dockerzhang commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
dockerzhang commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188703610
> 还有个问题，我在数据分组那里，选择执行日志，然后对失败的步骤点击执行，就会报错  
>
> 查看manager容器日志，得到以下信息：  
hi, @z1076398926 this bug has been fixed, please use the latest image, which builds from the master branch.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] z1076398926 commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
z1076398926 commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188840743
> As for the hive exception, we find the same issue, and another contributor will fix it later. 
好的，谢谢
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [inlong] z1076398926 commented on issue #5113: [Bug]Error executing SQL query "select "DB_ID" from "DBS"". Table/View 'DBS' does not exist.
Posted by GitBox <gi...@apache.org>.
z1076398926 commented on issue #5113:
URL: https://github.com/apache/inlong/issues/5113#issuecomment-1188912765
> @z1076398926 after #5128 merged, you can try if there still is the hive exception
谢谢，但我现在暂时没法测试，因为用了Master之后，出现了新的问题，我已经开了一个新的Issue，并且您已经在那个Issue中回复。
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org