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

Add array support #3

Open
sylphy-zh opened this issue Sep 4, 2017 · 4 comments

Comments

@sylphy-zh
Copy link

commented Sep 4, 2017

If I create table 'USER', and it's schema defined 'PERSONA'.

database_url = "http://master:8765/"
conn = phoenixdb.connect(database_url, autocommit=True)
cursor = conn.cursor()
cursor.execute("SELECT * FROM USER")

It has a error: Table undefined , tableName='USER'.
But When I use below query:

SELECT * FROM PERSON.USER

this will have a ERROR: UnsupportedOperationException: Currently not supported.

When I see the source code and not found anywhere I can specify the schema parameter.

How to solve this? Any idea?

@lalinsky

This comment has been minimized.

Copy link
Owner

commented Sep 4, 2017

How did you get the query server running with schema support? I'm trying to do it myself, but I'm failing on this:

Inconsistent namespace mapping properites.. Ensure that config phoenix.schema.isNamespaceMappingEnabled is consitent on client and server.

Can you please share how are you running the query server?

lalinsky added a commit that referenced this issue Sep 4, 2017
@lalinsky

This comment has been minimized.

Copy link
Owner

commented Sep 4, 2017

I have added a test to check that schema support works:

424a375

I'm unable to reproduce your problem. Can you please describe how are you running HBase/Phoenix?

@sylphy-zh

This comment has been minimized.

Copy link
Author

commented Sep 5, 2017

@lalinsky Thanks for your response. When I see some doc found that the phoenixdb is still not support array type field. Because there have some array type fields in my table, and query the non-array fields is ok. But when I use /path/to/phoenix/sqlline.py, same query is work fine.

Env : phoenixdb => 0.7

phoenixdb use protocol buffer transport default, I don't know whether json is support to use array type fields. Docs seems still not suport now.

@lalinsky

This comment has been minimized.

Copy link
Owner

commented Sep 5, 2017

Array support is not implemented yet. It has been added to Avatica/Phoenix since I started working in this project, but the type encoding/decoding code still needs to be updated.

@lalinsky lalinsky changed the title phoenixdb.errors.ProgrammingError: u'Table undefined Add array support Sep 5, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.