Python compiled script giving error of “Can't load plugin: sqlalchemy.dialects:presto”

up vote
2
down vote

favorite

I compiled .py file with pyinstaller as follows:

pyinstaller --hidden-import presto --hidden-import scipy._lib.messagestream  --onefile main.py

When I ran the compiled file, I got the error:

sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:presto

p.s. I used sqlalchemy.engine to connect to presto like:

engine = create_engine('presto://presto.service.example.com:8080/hive/default')

I haven't found anything useful on google.

edited 16 hours ago

Ilja Everilä

22.4k33459

asked 22 hours ago

nullne

3314

The error doesn't occur if you run main.py without compiling?
– SuperShoot
19 hours ago

@SuperShoot no error occurs when running the script directly
– nullne
18 hours ago

2

Are you sure --hidden-import presto is correct? Seems like the DB-API driver is provided by PyHive. The package presto in pypi seems unrelated.
– Ilja Everilä
18 hours ago

@IljaEverilä yes you are right, I tried many different packages as hidden import, but failed, including pyhive
– nullne
16 hours ago

This might also have something to do with how 3rd party dialects are registered using entry points. Perhaps pyinstaller requires some hand holding with that?
– Ilja Everilä
16 hours ago

|
show 1 more comment

up vote
2
down vote

favorite

I compiled .py file with pyinstaller as follows:

pyinstaller --hidden-import presto --hidden-import scipy._lib.messagestream  --onefile main.py

When I ran the compiled file, I got the error:

sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:presto

p.s. I used sqlalchemy.engine to connect to presto like:

engine = create_engine('presto://presto.service.example.com:8080/hive/default')

I haven't found anything useful on google.

edited 16 hours ago

Ilja Everilä

22.4k33459

asked 22 hours ago

nullne

3314

The error doesn't occur if you run main.py without compiling?
– SuperShoot
19 hours ago

@SuperShoot no error occurs when running the script directly
– nullne
18 hours ago

2

Are you sure --hidden-import presto is correct? Seems like the DB-API driver is provided by PyHive. The package presto in pypi seems unrelated.
– Ilja Everilä
18 hours ago

@IljaEverilä yes you are right, I tried many different packages as hidden import, but failed, including pyhive
– nullne
16 hours ago

This might also have something to do with how 3rd party dialects are registered using entry points. Perhaps pyinstaller requires some hand holding with that?
– Ilja Everilä
16 hours ago

|
show 1 more comment

up vote
2
down vote

favorite

I compiled .py file with pyinstaller as follows:

pyinstaller --hidden-import presto --hidden-import scipy._lib.messagestream  --onefile main.py

When I ran the compiled file, I got the error:

sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:presto

p.s. I used sqlalchemy.engine to connect to presto like:

engine = create_engine('presto://presto.service.example.com:8080/hive/default')

I haven't found anything useful on google.

edited 16 hours ago

Ilja Everilä

22.4k33459

asked 22 hours ago

nullne

3314

I compiled .py file with pyinstaller as follows:

pyinstaller --hidden-import presto --hidden-import scipy._lib.messagestream  --onefile main.py

When I ran the compiled file, I got the error:

sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:presto

p.s. I used sqlalchemy.engine to connect to presto like:

engine = create_engine('presto://presto.service.example.com:8080/hive/default')

I haven't found anything useful on google.

python sqlalchemy pyinstaller prestodb

edited 16 hours ago

Ilja Everilä

22.4k33459

asked 22 hours ago

nullne

3314

edited 16 hours ago

Ilja Everilä

22.4k33459

asked 22 hours ago

nullne

3314

edited 16 hours ago

Ilja Everilä

22.4k33459

edited 16 hours ago

Ilja Everilä

22.4k33459

edited 16 hours ago

Ilja Everilä

22.4k33459

asked 22 hours ago

nullne

3314

asked 22 hours ago

nullne

3314

asked 22 hours ago

nullne

3314

The error doesn't occur if you run main.py without compiling?
– SuperShoot
19 hours ago

@SuperShoot no error occurs when running the script directly
– nullne
18 hours ago

2

Are you sure --hidden-import presto is correct? Seems like the DB-API driver is provided by PyHive. The package presto in pypi seems unrelated.
– Ilja Everilä
18 hours ago

@IljaEverilä yes you are right, I tried many different packages as hidden import, but failed, including pyhive
– nullne
16 hours ago

This might also have something to do with how 3rd party dialects are registered using entry points. Perhaps pyinstaller requires some hand holding with that?
– Ilja Everilä
16 hours ago

|
show 1 more comment

The error doesn't occur if you run main.py without compiling?
– SuperShoot
19 hours ago

@SuperShoot no error occurs when running the script directly
– nullne
18 hours ago

2

Are you sure --hidden-import presto is correct? Seems like the DB-API driver is provided by PyHive. The package presto in pypi seems unrelated.
– Ilja Everilä
18 hours ago

@IljaEverilä yes you are right, I tried many different packages as hidden import, but failed, including pyhive
– nullne
16 hours ago

This might also have something to do with how 3rd party dialects are registered using entry points. Perhaps pyinstaller requires some hand holding with that?
– Ilja Everilä
16 hours ago

The error doesn't occur if you run main.py without compiling?
– SuperShoot
19 hours ago

@SuperShoot no error occurs when running the script directly
– nullne
18 hours ago

Are you sure --hidden-import presto is correct? Seems like the DB-API driver is provided by PyHive. The package presto in pypi seems unrelated.
– Ilja Everilä
18 hours ago

@IljaEverilä yes you are right, I tried many different packages as hidden import, but failed, including pyhive
– nullne
16 hours ago

This might also have something to do with how 3rd party dialects are registered using entry points. Perhaps pyinstaller requires some hand holding with that?
– Ilja Everilä
16 hours ago

|
show 1 more comment

active

oldest

votes

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53367842%2fpython-compiled-script-giving-error-of-cant-load-plugin-sqlalchemy-dialectsp%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

active

oldest

votes

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Ytukyg