Re: huge query result miss some fields

2016-11-24 Thread Abel Fernández
Hi Jinzhuan, Have you tried to update the statistics of your table? https://phoenix.apache.org/update_statistics.html On Thu, 24 Nov 2016 at 11:46 金砖 wrote: > hi, all: > > I’m using phoenix-4.8.0-hbase-1.1 with hbase 1.1.3. > > When query a lot of rows(ex: 100,000), some

ERROR 1013 (42M04): Table already exists. tableName=CARDS.TRANSACTIONS (state=42M04,code=1013)

2016-11-11 Thread Abel Fernández
Good Evening, I am having some problems when I am trying to create a table. I have deleted the table 'CARDS.TRANSACTIONS' from 'SYSTEM.CATALOG' and from hbase, using the hbase shell (disable and drop). The table I am trying to create is not listed when I use the phoenix shell (!tables) and

Apache Phoenix with HBaseTestingUtility and MiniKdc

2016-05-11 Thread Abel Fernández
Hello, I am trying to set up an unit test in local environment for testing Apache Phoenix with kerberos. Does anyone did something similar in the past? I am able to start the minicluster with kerberos but when I am getting the connection from the url I am always having the same error:

Load HFiles in Apache Phoenix

2016-04-27 Thread Abel Fernández
Hi, I am trying to load files in Apache Phoenix using HFiles. I do not have a csv so I need to load the Hfiles from a RDD. My problem is that I am not able to see the files using the apache api (select * from...) but when I do a scan of the table I see the files. Do I need to include the empty