You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@kyuubi.apache.org by "Ocean22 (via GitHub)" <gi...@apache.org> on 2023/11/23 03:29:20 UTC
[I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Ocean22 opened a new issue, #5753:
URL: https://github.com/apache/kyuubi/issues/5753
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
### Search before asking
- [X] I have searched in the [issues](https://github.com/apache/kyuubi/issues?q=is%3Aissue) and found no similar issues.
### What would you like to be improved?
1、Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row, and no execute time at tail
2、Want it no useless blank row,just like `spark-sql`client
### How should we improve?
Maybe can modify source code or add log file to control it
### Are you willing to submit PR?
- [ ] Yes. I would be willing to submit a PR with guidance from the Kyuubi community to improve.
- [X] No. I cannot submit a PR at this time.
--
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@kyuubi.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "pan3793 (via GitHub)" <gi...@apache.org>.
pan3793 commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1824060853
May that cause error messages lost if redirecting `stderr` to `/dev/null`?
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "Ocean22 (via GitHub)" <gi...@apache.org>.
Ocean22 commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1953334803
@cxzl25 Thanks for your tip.
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "Ocean22 (via GitHub)" <gi...@apache.org>.
Ocean22 commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1840077829
Thanks for @wForget's guidance,we can merge `stderr` and `stdout`,then use `grep -v '^$'` to solve this problem.
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "Ocean22 (via GitHub)" <gi...@apache.org>.
Ocean22 commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1823956414
Thanks for your test,and I tested it just now,even no `comment lines` and `empty lines`,it will still get blank row.Do you have any way to solve it?
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1823780636
Hello @Ocean22,
Thanks for finding the time to report the issue!
We really appreciate the community's efforts to improve Apache Kyuubi.
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "wForget (via GitHub)" <gi...@apache.org>.
wForget commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1824017849
The empty lines seem to be printed by `ConsoleReader#accept` and output to stderr , so we can solve it like:
```
-f XXX.sql 2>/dev/null
```
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "wForget (via GitHub)" <gi...@apache.org>.
wForget commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1823942539
@Ocean22 Thanks for your report. It may be caused by `comment lines` or `empty lines` in your script.
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "wForget (via GitHub)" <gi...@apache.org>.
wForget commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1824237349
> May that cause error messages lost if redirecting `stderr` to `/dev/null`?
Yes, error messages are also lost.
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "wForget (via GitHub)" <gi...@apache.org>.
wForget commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1823947791
I did a simple test to reproduce it.
execute script with the following content:
```
-- 111
-- 2222
-- 333
use sample;
show tables;
```
get the following print:
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org
Re: [I] [Improvement] Use `beeline --silent=true -u "**" -f` to execute a sql file will get many blank row [kyuubi]
Posted by "cxzl25 (via GitHub)" <gi...@apache.org>.
cxzl25 commented on issue #5753:
URL: https://github.com/apache/kyuubi/issues/5753#issuecomment-1952432731
> no execute time at tail
Hive4 has added a new option to support output execution time, `--silent=true --report=true`, but Kyuubi uses Hive3.
HIVE-22204: Beeline option to show/not show execution report
https://issues.apache.org/jira/browse/HIVE-22204
--
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@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org