You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@linkis.apache.org by "ly-yhq (via GitHub)" <gi...@apache.org> on 2023/05/15 02:05:52 UTC
[GitHub] [linkis] ly-yhq opened a new issue, #4542: scriptis使用hql查询hive30001报错
ly-yhq opened a new issue, #4542:
URL: https://github.com/apache/linkis/issues/4542
### Before asking
- [X] I have read the [How to ask for help](https://linkis.apache.org/community/how-to-ask-for-help) (我已阅读[如何寻求帮助](https://linkis.apache.org/zh-CN/community/how-to-ask-for-help)指引文档).
### Your environment
<!-- Please describe the linkis version you are using and basic environment information -->
<!-- 请描述您使用的linkis版本和基本环境信息 -->
- Linkis version used: 1.1.2
- Environment name and version:
- hdp-2.7.2
- hive-2.3.3
- spark-2.4.3
- scala-2.13.0
- jdk 1.8.0_351
### Describe your questions
<!-- Please describe your questions -->
<!-- 请描述您的问题 -->
Q1. 在scriptis中可以使用spark引擎查询hive 数据，但是直接用hql 查询报错
![Uploading image.png…]()
### Eureka service list
<!-- You can directly copy and paste the screenshot of the list of registered service instances displayed on the Eureka page here -->
<!-- 可以将Eureka页面显示的注册服务实例列表的的截图 直接复制并粘贴到这里。 粘贴后，会自动生成如下格式的url-->
### Some logs info or acctch file
<!-- Please add the log in the following format, the key error log must be pasted in the code style, and the text as much as possible, the detailed log or other files can be dragged and uploaded as an attachment -->
<!-- 请按如下格式 添加日志，关键错误日志请贴到[````log][````]之间，尽可能贴文字，详细日志或则其它文件，可以拖拽上传作为附件 -->
linkis-xxx.log:
````log
<!--日志文字贴到这里-->
2023-05-15 09:44:24.044 INFO Program is substituting variables for you
2023-05-15 09:44:24.044 INFO Variables substitution ended successfully
2023-05-15 09:44:24.044 INFO SQL code check has passed
2023-05-15 09:44:24.044 INFO Job with jobId : 31 and execID : IDE_root_hive_0 submitted
2023-05-15 09:44:24.044 INFO You have submitted a new job, script code (after variable substitution) is
************************************SCRIPT CODE************************************
select * from demo.ods_acdm_fims_add3 limit 100
************************************SCRIPT CODE************************************
2023-05-15 09:44:24.044 INFO Your job is accepted, jobID is exec_id018010linkis-cg-entrancegzx01:9104IDE_root_hive_0 and taskID is 31 in ServiceInstance(linkis-cg-entrance, gzx01:9104). Please wait it to be scheduled
2023-05-15 09:44:24.044 INFO Your job is Scheduled. Please wait it to run.
2023-05-15 09:44:24.044 INFO job is scheduled.
2023-05-15 09:44:24.044 INFO Your job is being scheduled by orchestrator.
2023-05-15 09:44:24.044 INFO Your job is Running now. Please wait it to complete.
2023-05-15 09:44:24.044 INFO job is running.
2023-05-15 09:44:24.044 INFO JobRequest (31) was submitted to Orchestrator.
2023-05-15 09:44:24.044 INFO Background is starting a new engine for you,execId TaskID_31_otJobId_astJob_30_codeExec_30 mark id is mark_30, it may take several seconds, please wait
2023-05-15 09:44:25.044 ERROR jobRequest(IDE_root_hive_0) execute failed,21304, Task is Failed,errorMsg: errCode: 12003 ,desc: gzx01:9101_17 Failed to async get EngineNode AMErrorException: errCode: 30001 ,desc: Failed to createEngine ask em ServiceInstance(linkis-cg-engineconnmanager, gzx01:9102) ,ip: gzx01 ,port: 9101 ,serviceKind: linkis-cg-linkismanager ,ip: gzx01 ,port: 9104 ,serviceKind: linkis-cg-entrance
2023-05-15 09:44:25.044 INFO Task creation time(任务创建时间): 2023-05-15 09:44:24, Task scheduling time(任务调度时间): 2023-05-15 09:44:24, Task start time(任务开始时间): 2023-05-15 09:44:24, Mission end time(任务结束时间): 2023-05-15 09:44:25
2023-05-15 09:44:25.044 INFO Task submit to Orchestrator time:2023-05-15 09:44:24, Task request EngineConn time:not request ec, Task submit to EngineConn time:not submit to ec
2023-05-15 09:44:25.044 INFO Your mission(您的任务) 31 The total time spent is(总耗时时间为): 1.4 s
2023-05-15 09:44:25.044 INFO Sorry. Your job completed with a status Failed. You can view logs for the reason.
2023-05-15 09:44:25.044 INFO job is completed.
````
log file:
<!-- 拖拽上传后，会自动生成如下示例格式的附件url -->
[linkis-xxx.log](https://github.com/apache/linkis/files/9219529/yarn-error.log)
--
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: notifications-unsubscribe@linkis.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@linkis.apache.org
For additional commands, e-mail: notifications-help@linkis.apache.org
[GitHub] [linkis] ly-yhq closed issue #4542: scriptis使用hql查询hive30001报错
Posted by "ly-yhq (via GitHub)" <gi...@apache.org>.
ly-yhq closed issue #4542: scriptis使用hql查询hive30001报错
URL: https://github.com/apache/linkis/issues/4542
--
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: notifications-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@linkis.apache.org
For additional commands, e-mail: notifications-help@linkis.apache.org
[GitHub] [linkis] github-actions[bot] commented on issue #4542: scriptis使用hql查询hive30001报错
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #4542:
URL: https://github.com/apache/linkis/issues/4542#issuecomment-1547093164
## :blush: Welcome to the Apache Linkis community!!
We are glad that you are contributing by opening this issue.
Please make sure to include all the relevant context.
We will be here shortly.
If you are interested in contributing to our website project, please let us know!
You can check out our contributing guide on
:point_right: [How to Participate in Project Contribution](https://linkis.apache.org/community/how-to-contribute).
### Community
|WeChat Assistant|WeChat Public Account|
|-|-|
|<img src="https://linkis.apache.org/Images/wedatasphere_contact_01.png" width="128"/>|<img src="https://linkis.apache.org/Images/gzh_01.png" width="128"/>|
### Mailing Lists
|Name|Description|Subscribe|Unsubscribe|Archive|
|:-----|:--------|:------|:-------|:-----|
| [dev@linkis.apache.org](mailto:dev@linkis.apache.org) | community activity information | [subscribe](mailto:dev-subscribe@linkis.apache.org) | [unsubscribe](mailto:dev-unsubscribe@linkis.apache.org) | [archive](http://mail-archives.apache.org/mod_mbox/linkis-dev) |
--
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: notifications-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@linkis.apache.org
For additional commands, e-mail: notifications-help@linkis.apache.org