Are values of a sequence deleted after an incrementation?

I am not sure how sequences work in phoenix but something popped up in my mind. If I request 100 values from a sequence will there be 100 values stored in the database or just 1 value which is "100" telling phoenix the is the number to be incremented?

Select date range performance issue

Hi all, I've seen performance problem when selecting rows within date range. My table schema is: CREATE TABLE MY_TABLE ( OBJ_ID varchar(20) not null, CREATE_DT timestamp not null, KEYWORD varchar(100) not null, COUNT integer, CONSTRAINT PK PRIMARY KEY (OBJ_ID,CREATE_DT,KEYWORD) );

Re: Phoenix query performance

why cant you reduce your query to select msbo1.PARENTID from msbo_phoenix_comp_rowkey where msbo1.PARENTTYPE = 'SHIPMENT' and msbo1.OWNERORGID = 100 and msbo1.MILESTONETYPEID != 19661 and msbo1.PARENTREFERENCETIME between 1479964000 and 1480464000 group by msbo1.PARENTID order

Re: Phoenix Query Server tenant_id

Also, remember that Bash is going to interpret that semi-colon in your URL if you don't quote it. It will be treated as two separate commands: `/usr/hdp/2.5.0.0-1245/phoenix/bin/sqlline-thin.py http://pqs1.mydomain.com:8765` and `TenantId=myTenant` Please try

Re: Phoenix Query Server tenant_id

So, just that I'm on the same page as you, when you invoke the Java application yourself, it works fine, but when you use sqlline-thin.py, the extra argument is dropped? If so, that just sounds like a bug in sqlline-thin.py that we could fix... If you're skilled in Python (or even just

Re: Phoenix query performance

Hi Pradheep, Thank you for the answers! Please see my response inline. On Wed, Feb 22, 2017 at 12:39 PM, Pradheep Shanmugam < pradheep.shanmu...@infor.com> wrote: > Hi Maryann > > Please find my answers inline. > > Thanks, > Pradheep > > From: Maryann Xue > Reply-To:

Re: Phoenix query performance

Hi Maryann Please find my answers inline. Thanks, Pradheep From: Maryann Xue > Reply-To: "user@phoenix.apache.org" > Date: Wednesday, February 22, 2017 at

Re: Phoenix query performance

Hi Pradheep, Thank you for posting the query and the log file! There are two things going on on the server side at the same time here. I think it'd be a good idea to isolate the problem first. So a few questions: 1. When you say data size went from "< 1M" to 30M, did the data from both LHS and