assandra.InvalidRequest: Error from server: code=2200 [Invalid query] message="Invalid INTEGER constant (42607589003) for Identifier of type text"

Question

I am trying to run a simple query on cassandra host via python.

>>session.execute('SELECT * from "users" WHERE "userid"=42607589003')

But i get error below,"userid" is of type text, i tried different permutations by enclosing in double quotes too, but cannot figure out why this error is thrown

>>cassandra.InvalidRequest: Error from server: code=2200 [Invalid query] message="Invalid INTEGER constant (42607589003) for Identifier of type text"

can somebody let me know whats wrong here?

Why do you need quotes around users and userid? did you try this? "SELECT * FROM users WHERE userid='abc'" — Tejas
– Tejas, Commented Sep 14, 2017 at 21:46
without quotes would give me this error: cassandra.InvalidRequest: Error from server: code=2200 [Invalid query] message="unconfigured columnfamily users" — chetan honnavile
– chetan honnavile, Commented Sep 14, 2017 at 21:51
i doubt i can give the whole schema. but the userid is of 'text' — chetan honnavile
– chetan honnavile, Commented Sep 14, 2017 at 22:19

Chris Lohfink · Accepted Answer · 2017-09-14 21:45:45Z

1

42,607,589,003 isn't representable as a 32 bit integer. Have you tried it without quotes?

answered Sep 14, 2017 at 21:45

Chris Lohfink

16.5k1 gold badge32 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ScooredMars · Accepted Answer · 2022-02-22 16:47:22Z

1

Propably you set your variable in cassandra "userid" as text and you trying to send int 42607589003.

Change this: session.execute('SELECT * from "users" WHERE "userid"=42607589003') To this: session.execute("SELECT * from users WHERE userid='42607589003'")

answered Feb 22, 2022 at 16:47

ScooredMars

212 bronze badges

Collectives™ on Stack Overflow

assandra.InvalidRequest: Error from server: code=2200 [Invalid query] message="Invalid INTEGER constant (42607589003) for Identifier of type text"

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related