Hi There,
I have a query which is failing when executing through JDBC (using spring
jdbctemplate) but when the same query is executed through sqlline it is
working fine.
the thing is the column does not belong to my table at all.
Here is the Stack Trace of the error when executing through JDBC
Hi There,
Can I get any phoenix column in Natural sort order?
For eg:
If I have column with values as
test11
test500
42
test9
test3
1
51
then the output should be like
1
42
51
test3
test9
test11
test500
any suggestions please?
Thanks,
PS: I have used AlphonumComparator class referred fr
Hi Team,
Any idea with this issue? We are struck up with this issue and we need to
provide a solution before Jan 8th.
Any sugesstions, guidance please.
Thanks,
Durga Prasad
On Thu, Dec 31, 2015 at 12:14 PM, Ns G wrote:
> Hi There,
>
> Here is my JDBC connection string.
>
> My H
Thanks,
Durga Prasad
On Tue, Dec 29, 2015 at 11:01 PM, Josh Elser wrote:
>
>
> Ns G wrote:
>
>> Hi All,
>>
>> I have written a simple class to access phoenix.
>> I am able to establish connection. But when executing below line i get
>> the error.
Hi All,
I have written a simple class to access phoenix.
I am able to establish connection. But when executing below line i get the
error.
conn = DriverManager.getConnection(dbUrl);
I am facing below exception when accessing phoenix through JDBC from
eclipse.
INFO - Call exception, tries=25, r
Hi Team,
I want to fetch records with date column between current date and a past
date.
Currently when i use between in phoenix it is not working.
Can any one help?
Query:
SELECT id,to_date(SUBSTR(ID2, (LENGTH(ID2)-7), 8),'MMdd','GMT') FROM
table1 h WHERE to_date(SUBSTR(ID2, (LENGTH(ID2)-7
eleases. I have updated that post today. Please let me know if you would
> like me to add anything else.
>
> @Ns G, Please follow the post and let us know how it goes. It should be
> pretty easy.
>
> Thanks,
> Anil Gupta
>
> On Tue, Dec 22, 2015 at 10:24 PM, James Taylor
>
Hi There,
Can any one provide me guidelines on how to install and access phoenix on a
kerberised cluster? How to use keytab in jdbc to connect to phoenix?
Thanks,
Hi All,
I have a query that executes and gives correct value through sqlline but
when executing through spring jdbc template it is giving me the error
" PhoenixIOException: The system cannot find the path specified". any idea
y this is so?
Thanks,
Durga Prasad
Hi James,
I didn't try that. Now after that change it is working. Very trivial error
from my end.
Thanks,
Durga Prasad
On 15-Oct-2015 11:51 am, "James Taylor" wrote:
> Have you tried double single quotes for the escaping?
>
> On Wed, Oct 14, 2015 at 11:19 PM, Ns
; wrote:
> Kind of a guess, but if you're parsing a single SQL statement, it
> shouldn't have a semicolon at the end. If that's part of the string, can
> you try removing it?
>
> On Wed, Oct 14, 2015 at 11:11 PM, Ns G wrote:
>
>> Hi All,
>>
>>
Hi All,
I have a requirement where in i need to create tables to JDBC (actually
Spring).
I have written the below code
protected Boolean executeScript(final Reader reader, String action, Long
serviceId) throws IOException, SQLException {
try {
long start = System.currentTimeM
> column names?
> Thanks,
> James
>
> On Tuesday, September 22, 2015, Ns G wrote:
>
>> Hi Team,
>>
>> I have a column with unsigned_int as the data type.
>> when i try to use not in clause with limit, it is not working. The outer
>> query is fetching t
Hi Team,
I have a column with unsigned_int as the data type.
when i try to use not in clause with limit, it is not working. The outer
query is fetching the records that satisfy the query in not in condition.
Can any one suggest if this is bug?
I am using cloudera and Phoenix 4.5.1 version.
When
, 2015 at 1:47 AM, Ns G wrote:
>
>> Hi There,
>>
>> Can any one provide an answer?
>> Can I use PhoenixMapReduceUtil to read two different tables in a single
>> mapreduce program (in mapper)
>>
>> Thanks,
>>
>> On Thu, Sep 10, 2015 at 8:41 P
Hi There,
Can any one provide an answer?
Can I use PhoenixMapReduceUtil to read two different tables in a single
mapreduce program (in mapper)
Thanks,
On Thu, Sep 10, 2015 at 8:41 PM, Ns G wrote:
> Hi Ravi,
>
> Can we read mutiple tables through map reduce? Do we have any
Hi Ravi,
Can we read mutiple tables through map reduce? Do we have any JIRA for
implementing this?
Thanks,
Durga Prasad
On Mon, Aug 10, 2015 at 6:18 AM, Ravi Kiran
wrote:
> Hi Peeranat,
>
>With the current implementation , there isn't an option to write to
> multiple phoenix tables .
>
> T
; James
>
> On Thursday, August 27, 2015, Ns G wrote:
>
>> Hi James,
>>
>> I think we can get the dynamic column names from SYSTEM.CATALOG table.
>> Using as co-related sub query we can use in select statement and fetch
>> details. Isn't this an opt
Hi James,
I think we can get the dynamic column names from SYSTEM.CATALOG table.
Using as co-related sub query we can use in select statement and fetch
details. Isn't this an option to consider? Do you see anything wrong with
this approach?
Thanks,
Satya
On 27-Aug-2015 7:28 pm, "Manjee, Sunile"
,
>>
>> Unless you call NEXT VALUE FOR on a sequence *the first time*, you
>> wouldn't be getting the CURRENT VALUE . So , instead of getting the
>> CURRENT VALUE, you can get the NEXT VALUE and then pass to your upsert
>> query.
>>
>> Hope this help
Hi All,
I have a requirement where the sequence number is to be prefetched and then
used in upsert query.
I know that Current Value for a sequence number gives me the last used
value. But It does not return value for the first time until and unless
used in a upsert query.
Is there any alternati
Hi Lukas,
I have shared the changes I made in one of the previous email. Did u try
them?
Thanks,
Satya
On 22-Aug-2015 6:51 pm, "Lukáš Lalinský" wrote:
> On Sat, Aug 22, 2015 at 1:26 AM, Ns G wrote:
>
>> But, what I can suggest is with minimal changes to the phoenix code
Hi Buntudev,
As per my knowledge there is no planned release for phoenix 4.4 version or
above. As you might be aware already, phoenix is in cloudera labs so there
is a limited support.
But, what I can suggest is with minimal changes to the phoenix code you
will be able to build & deploy phoenix o
How about loading the data as data frame or RDD and just save the data to
new salted table and drop earlier table. I feel spark is very very fast
than MR. Just my idea though
On 18-Aug-2015 10:42 pm, "James Taylor" wrote:
> You can use UPSERT SELECT from the old table to the new table and do this
rted by the broader Phoenix
>>> map-reduce integration, which the phoenix-spark module uses under the hood.
>>>
>>> One workaround that would give you sequential IDs, is to use the
>>> 'zipWithIndex' method on the underlying Spark RDD, with a small '
No issues Thanks for your time
On 15-Aug-2015 9:41 pm, "anil gupta" wrote:
> Sorry, i haven't tried out Spark-Phoenix.
>
> On Sat, Aug 15, 2015 at 8:49 AM, Ns G wrote:
>
>> Hi Anil
>>
>> Thanks for your reply albeit bit late. Yea I recognized it
help on this please?
Thanks,
Satya
On 15-Aug-2015 8:44 pm, "anil gupta" wrote:
> That a basic group by principle in SQL. You will need to add the column in
> group by.
>
> On Sat, Jun 13, 2015 at 12:47 AM, Ns G wrote:
>
>> Hi Team,
>>
>> I am trying to
Hi All,
I hope that someone will reply to this email as all my previous emails have
been unanswered.
I have 10-20 Million records in file and I want to insert it through
Phoenix-Spark.
The table primary id is generated by a sequence. So, every time an upsert
is done, the sequence Id gets generate
Hi All,
I am using Apache phoenix 4.3.1 version of Cloudera labs.
I have one of the column in a table like below
Name
FUR EARMUFFS BLACK ONE V
FUR EARMUFFS BLACK ONE V
T ROSE GOLD LARIAT MULTI ONE
T ROSE GOLD LARIAT MULTI ONE
UNISEX SNUGGLER IVORY ONE NV
UNISEX SNUGGLER IVORY ONE NV
so when i
, 2015 at 3:39 PM, Ns G wrote:
> HI There,
>
> I have a query like one below
>
> UPDATE table_1
> SETid1 = (SELECT Min(id1)
> FROM table_1 t2
> WHERE table_1.id3 = t2.id3)
> WHERE id3 = id4
>
> I am trying to implement this in Apach
Hi All,
I want to query a table after finding all the columns for a table that
belong to a column family from system catalog.
I have written the below query
SELECT 'SELECT ' ||
ARRAY_TO_STRING(ARRAY(SELECT COLUMN_NAME::VARCHAR(50)
FROM SYSTEM.CATALOG
WHERE TABLE_SCHEM ='SCM_262' AND COLUMN_FAMIL
Thanks Thomas. I will try out.
On 22-Jul-2015 6:24 am, "Thomas D'Silva" wrote:
> The default regex functions just use Java Pattern
>
>
> On Tue, Jul 21, 2015 at 2:28 AM, Ns G wrote:
> > Hi All,
> >
> > I have a requirement for using Regular exp
Hi All,
I have a requirement for using Regular expression. I am trying below query
but it doesnt seem to work.
SELECT el_id from element where el_name like
REGEXP_SUBSTR(el_name,'^[Z][A-Za-z0-9 \.]*')
I dont know if this is correct usage or not. If you can point me any source
where i can get it
gt; copies of this communication and any attachment.
>
> On Jul 14, 2015, at 5:09 AM, Ns G wrote:
>
> HI There,
>
> I have a query like one below
>
> UPDATE table_1
> SETid1 = (SELECT Min(id1)
> FROM table_1 t2
> WHERE table_1.id3 = t2.
HI There,
I have a query like one below
UPDATE table_1
SETid1 = (SELECT Min(id1)
FROM table_1 t2
WHERE table_1.id3 = t2.id3)
WHERE id3 = id4
I am trying to implement this in Apache Phoenix. Can anyone suggest how
should i be doing this as we do not have set command in
ble1 and
> not NDM_17.TABLE1 ?
>
> Regards
> Ravi
>
> On Thu, Jul 9, 2015 at 10:09 AM, Ns G wrote:
>
>> Hi Ravi Kiran,
>>
>> Thanks for your response. Yes I have tried the way you have suggested
>> already and still got failure message.
>>
>>
ader('regionserver');
>
> I am also hoping the 'regionserver' mentioned above is the zookeeper
> quorum.
>
> Regards
> Ravi
>
> On Thu, Jul 9, 2015 at 6:35 AM, Ns G wrote:
>
>> Hi there,
>>
>> I am trying to read a phoenix table thro
Hi there,
I am trying to read a phoenix table through pig but i am facing error and
unable to read. we are using Cloudera version of phoenix (4.3.1)
I have given command like
register /home/satya/phoenix-4.3.1-client.jar;
and then the PIG Command:
s = load 'hbase://ndm_17.table1/' using
org.apa
HI All,
I have a requirement where we need to implement pagination. My webapp uses
extJS as front end and they are implementing infinite scroll.
As the user scrolls down, a service request is sent to get the next page
and extjs doesn't have an option to selectively retrieve the last record to
use
Hi James,
Can you specify the time zone please?
Thanks
Satya
On 23-Jun-2015 9:32 am, "James Taylor" wrote:
> If you're interested in learning more about Phoenix, tune in this
> Thursday @ 10am where I'll be talking about Phoenix in a free Webcast
> hosted by O'Reilly: http://www.oreilly.com/pub
Hi All,
I am working on a Java Spring project where wer are connecting to Phoenix
and loading a file or trying to upsert a record through Spring(MVC).
The process executes correctly for some X number of records and then
suddenly all the threads get closed and main thread keeps running without
an
Hi Team,
I am trying to execute below query. I want all the columns in the table but
i get error if i include the columns not under group by. Can someone please
help me how to execute this query in phoenix?
select ELS_ID_CODE1, ELS_ID_CODE2, ELS_NAME, ELS_DESC, ELS_ACTIVE, max (
ELS_TIME_ID ) fr
Hello Friends,
I have requirement in my project to create a record (primary key being id).
This is generated by a sequence. So, when i create a record, i use "NEXT
VALUE FOR . I need to fetch the id of this sequence and insert in
another row of the same table.
The application is web application a
e 'cftable' and
> 'server_name' is your zookeeper quorum , things should be working.
>
> Can you please confirm.
>
> Regards
> Ravi
>
> On Fri, Jun 5, 2015 at 4:53 AM, Ns G wrote:
>
>> Hi Team,
>>
>> I am trying to connect to Pho
On Wed, Jun 3, 2015 at 8:32 PM, James Taylor
> wrote:
>
>> Wrong group. The Google group is no longer active. Please use the Apache
>> dev mailing list: http://phoenix.apache.org/mailing_list.html
>>
>>
>> On Wednesday, June 3, 2015, Ns G wrote:
>>
>&
45 matches
Mail list logo
