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

【insert_dataframe】Unsupported column type: <class 'numpy.ndarray'>. list or tuple is expected. #318

Closed
RonnieHu opened this issue Jun 10, 2022 · 4 comments

Comments

@RonnieHu
Copy link

when i tried to use the client.insert_dataframe(sql, dataframe), it jut crashed.

image

image

@RonnieHu
Copy link
Author

the pandas.dataframe has created, but it cannnot use the insert_dataframe, why?

@xzkostyan
Copy link
Member

I'm unable to reproduce this issue with provided information. Please provide snippet that will cause this error with data and CREATE TABLE query.

@RonnieHu
Copy link
Author

I'm unable to reproduce this issue with provided information. Please provide snippet that will cause this error with data and CREATE TABLE query.

this is the table:
image

this is the source code with 'insert_dataframe'
image

this is the output info:
image

Thank u for your concern :)

@RonnieHu
Copy link
Author

I'm unable to reproduce this issue with provided information. Please provide snippet that will cause this error with data and CREATE TABLE query.

I've solved this problem by setting client = Client('localhost', settings={"use_numpy":True})
thank you for your try to help me.
Would you like to improve the docs about insert_dataframe() with client settings? This would help others to solve the problem. : )

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants