Sorry it was my typo. No this was not an issue. But thanks for noticing.
BR
Jure
From: Steve Terrell [mailto:sterr...@oculus360.us]
Sent: Thursday, September 22, 2016 5:36 PM
To: user@phoenix.apache.org
Subject: Re: Problems running queries (not same amount of results)
Could it be due to a mistak
Also its not only the first time it takes time when we call
ResultSet.next().
When we iterate over ResultSet, it takes a long time initially and then
iterates faster. Again after few iterations, it takes sometime and this
goes on.
Sample observation:
Total Rows available on ResultSet : 5130
Hi Ankit,
Where does the server processing happens, on the HBase cluster
or the server where Phoenix core runs.
PFB the details you have asked for,
Query:
SELECT col1, col2, col5, col7, col11, col12 FROM SPL_FINAL where
col1='MK00100' and col2='YOU' and col3=4 and col5 in (?,?,?,?,?)
In all cases, the client throws if a write fails (i.e. data table or index
table failure). The state your table and index are left in depend on 1) how
you've configured your table, and 2) when the failure happened. This is
described here[1] in detail.
Here's a summary:
- If your table is transact
James, what are the "write failure scenarios" in this case? I can only
assume one, index update fails and client while trying to rewrite
to the index.
How does the statement below fair when an index cannot be updated. Does
client hang, throw error (leaving inconsistent results) or does the table
Actually, in Oracle, at least the last time I was working on it, if you divided
an int column by an int column, you got an int result which, if I remember
correctly, was truncated.
For people who write SQL, this is a fairly well known issue that we confront,
and solve using the solution propose
Could it be due to a mistake in your SQL?
select c1, c4, c5 from TABLE1 where (c4 = 'B')*)* AND (c1 <=
TO_DATE('22.09.2016
17:15:59', 'dd.MM. HH:mm:ss'));
looks like an out of place ")".
On Thu, Sep 22, 2016 at 4:10 AM, Jure Buble wrote:
> Hi,
>
> Anyone faced same problems as we are?
>
>
My problem is that my composite primary key can change, like shown here :
1 - Root ---> Project 1 --> Cluster 1 ---> Cluser 2 --> Building 1 --> Sensor
1
2- Root ---> Project 2--> Building 1 --> Sensor 1
3- Root ---> Building 3 --> Sensor 1
4- Root ---> Floor 3 --> Sensor 1
In some graph
But Phoenix does this for you (creates a composite key, special separator)
- you just have to specify the PK while creating the table.
CREATE TABLE IF NOT EXISTS us_population (
state CHAR(2) NOT NULL,
city VARCHAR NOT NULL,
population BIGINT
CONSTRAINT my_pk PRIMARY KEY (s
I checked both oracle and impala and in both 1/3 is 0.333 and not 0.
I think that SQL writer is not a programmer and he does not care about data
type. He just want to get the correct results. BTW – it is not only constant,
even expression like sum(case when then 1 else 0 end) / count(*)
will g
Thank you Josh, sure I'll do that.
On 2016-09-22 08:23 ( 0530), Josh Elser wrote:
> Sounds like the thin driver should be making a copy of the properties if
>
> its going to be modifying it. Want to open a JIRA issue?>
>
> Prabhjyot Singh wrote:>
> > Hi,>
> >>
> > I'm using DriverManager.getConne
I think it is fairly standard in programming languages for / to mean
integer division when the operands used are integers. Therefore 1/3=0 is
not a surprising result to me; other programming languages I have worked in
give 1/3=0. However if one of the operands to / is a decimal, the result
is als
Hi,
Anyone faced same problems as we are?
We are using phoenix 4.6 with hbase 1.1.2.
We have multiple entries in table. When we run query on that table with
condition for one of the columns in table, let's say for column 4, we don't
get hit for that condition.
E.g.: table row has under 4th colu
On Thu, 2016-09-22 at 05:39 +, Bulvik, Noam wrote:
We have an app that let user write their own SQL
Um, do they write DROP TABLE statements in there?
Elsevier Limited. Registered Office: The Boulevard, Langford Lane, Kidlington,
Oxford, OX5 1GB, United Ki
I'm designing a nosql database with hbase and phoenix, and i was thinking of
making a composite primary key in this form.
HbaseRowKey (path_id,sensor_id,date) and C.Value ( Column Family).
my path_id will be composed like this : R1#P1#C1#B2.
and i was thinking with a SQL request without knownin
Share some more details about the query, DDL and explain plan. In Phoenix,
there are cases where we do some server processing at the time when
rs.next() is called first time but subsequent next() should be faster.
On Thu, Sep 22, 2016 at 9:52 AM, Sasikumar Natarajan
wrote:
> Hi,
> I'm using
16 matches
Mail list logo