Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't execute multiple statements in Presto #49

Closed
greendisc777 opened this issue Jan 15, 2019 · 5 comments
Closed

Can't execute multiple statements in Presto #49

greendisc777 opened this issue Jan 15, 2019 · 5 comments

Comments

@greendisc777
Copy link

yanagishima version: 17.0

presto version: 0.215

conf/yanagishima.properties:
jetty.port=8090
presto.query.max-run-time-seconds=1800
presto.max-result-file-byte-size=1073741824
presto.datasources=your-presto
presto.coordinator.server.your-presto=http://server:8080
catalog.your-presto=hive
schema.your-presto=default
select.limit=500
audit.http.header.name=some.auth.header
to.values.query.limit=500
check.datasource=false
hive.jdbc.url.your-hive=jdbc:hive2://server:10000/default;
hive.jdbc.user.your-hive=hive
hive.jdbc.password.your-hive=password
hive.query.max-run-time-seconds=3600
hive.query.max-run-time-seconds.your-hive=3600
resource.manager.url.your-hive=http://server:8088
sql.query.engines=presto,hive
hive.datasources=your-hive
hive.max-result-file-byte-size=1073741824
hive.setup.query.path.your-hive=/usr/local/yanagishima/conf/hive_setup_query_your-hive
cors.enabled=false

JVM version (java -version): openjdk version "1.8.0_191"
OpenJDK Runtime Environment (build 1.8.0_191-b12)
OpenJDK 64-Bit Server VM (build 25.191-b12, mixed mode)

Server OS version (uname -a if on a Unix-like system): CentOS 3.10.0-957.1.3.el7.x86_64 #1 SMP

Client OS version

Browser: Chrome - Version 71.0.3578.98 (Official Build) (64-bit)

Description of the problem including expected versus actual behavior: Cannot execute multiple statements separated by ";"

Steps to reproduce: Example:

Please include a minimal but complete recreation of the problem, including
(e.g.) query execution, bookmark, settings, history etc. The easier you make for
us to reproduce it, the more likely that somebody will take the time to look at it.

  1. drop table <catalog.schema.tablename>;
  2. create table <catalog.schema.tablename> as select * from <catalog.schema.tablename>;

Provide logs (if relevant):

Provide screenshots (if relevant):
image

@wyukawa
Copy link
Contributor

wyukawa commented Jan 15, 2019

Duplicate of #24

@wyukawa wyukawa marked this as a duplicate of #24 Jan 15, 2019
@greendisc777
Copy link
Author

I'm not asking for multiple statements for Hive queries. This is pure Presto consuming hive tables.

@ebyhr
Copy link
Contributor

ebyhr commented Aug 31, 2019

@greendisc777 Even if we use Presto as the datasource, we can't execute multiple statements for now.

@greendisc777
Copy link
Author

The Presto CLI supports executing multiple statements in a file with each line terminated by ";"

@ebyhr
Copy link
Contributor

ebyhr commented Aug 31, 2019

Yes, I knew it. The hard point isn't parsing the queries. As mentioned in #24, simply it requires many changes. Please imagine multiple SELECT queries.

@ebyhr ebyhr changed the title Can't execute multiple statements Can't execute multiple statements in Presto Dec 10, 2020
@ebyhr ebyhr closed this as completed Apr 29, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants