Support Questions
Find answers, ask questions, and share your expertise

select * from working in Phoenix

select * from working in Phoenix

Master Collaborator

I see few posts here with same issue but no resolution ?

if I put the field names then it work .

0: jdbc:phoenix:localhost:2181:/hbase-unsecur> select * from ufm;
Error: ERROR 201 (22000): Illegal data. Expected length of at least 105 bytes, but had 44 (state=22000,code=201)
java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at least 105 bytes, but had 44
  
1 REPLY 1

Re: select * from working in Phoenix

Hey @Sami Ahmad!
Guess your facing an unmatched datatype.
Could you check if your datatype matches the data?

The links below has your err msgs :)
https://github.com/apache/phoenix/blob/29b76635944c717a5226e001abd85c045287344a/phoenix-core/src/mai...
https://github.com/apache/phoenix/blob/5b099014446865c12779f3882fd8b407496717ea/phoenix-core/src/mai...

Hope this helps! :)