[jira] [Commented] (PHOENIX-6679) PHOENIX-6665 changed column name for CURRENT seqence values

2022-03-31 Thread Istvan Toth (Jira)


[ 
https://issues.apache.org/jira/browse/PHOENIX-6679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17515715#comment-17515715
 ] 

Istvan Toth commented on PHOENIX-6679:
--

The script that links the PR back to the ticet is rather unreliable.

 

> PHOENIX-6665 changed column name for CURRENT seqence values
> ---
>
> Key: PHOENIX-6679
> URL: https://issues.apache.org/jira/browse/PHOENIX-6679
> Project: Phoenix
>  Issue Type: Bug
>  Components: core
>Affects Versions: 5.2.0
>Reporter: Romil Choksi
>Assignee: Istvan Toth
>Priority: Minor
>
> Due to changes in execution, I had to change the string value returned by 
> SequenceValueExpression (which is used as the column name)
> However, as the CURRENT keyword does not take a parameter, the column name 
> should have remained the same.
> Fix the column names, so that we return 
> {code:java}
> CURRENT VALUE FOR MYSEQUENCE{code}
> instead of 
> {code:java}
> CURRENT[1] VALUE(S) FOR MYSEQUENCE{code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Commented] (PHOENIX-6678) Dbeaver jdbc connetion for Phoenix

2022-03-31 Thread Lars Hofhansl (Jira)


[ 
https://issues.apache.org/jira/browse/PHOENIX-6678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17515672#comment-17515672
 ] 

Lars Hofhansl commented on PHOENIX-6678:


The email list [d...@phoenix.apache.org|mailto:d...@phoenix.apache.org] and 
[u...@phoenix.apache.org|mailto:u...@phoenix.apache.org] are very much alive 
and valid.

> Dbeaver jdbc connetion for Phoenix
> --
>
> Key: PHOENIX-6678
> URL: https://issues.apache.org/jira/browse/PHOENIX-6678
> Project: Phoenix
>  Issue Type: Bug
>  Components: connectors
>Affects Versions: 5.0.0
> Environment: Hbase 2.0.2
> Phoenix 5.0.0
>Reporter: Dmitry Kravchuk
>Priority: Major
> Attachments: image-2022-03-30-15-53-14-255.png, 
> image-2022-03-30-15-53-23-717.png, image-2022-03-30-15-55-19-706.png, 
> image-2022-03-30-15-56-42-691.png, image-2022-03-30-15-57-39-813.png, 
> image-2022-03-31-10-56-32-334.png, image-2022-03-31-10-57-11-856.png, 
> image-2022-03-31-10-57-26-287.png, image-2022-03-31-13-49-29-131.png, 
> image-2022-03-31-13-50-18-105.png, image-2022-03-31-13-50-45-594.png, 
> image-2022-03-31-13-51-07-925.png, image-2022-03-31-13-51-29-100.png
>
>
> I've been searching solution for successfull connection to Phoenix usig 
> DBeaven for a weeks and came here for help.
> Here is my HBase config:
> !image-2022-03-30-15-53-23-717.png!
> Here is my DBeaver connection properties:
> !image-2022-03-30-15-55-19-706.png!
> I've donwloaded phoenix and hbase jars from hadoop cluster as connection 
> drivers:
> !image-2022-03-30-15-56-42-691.png!
> Error:
> !image-2022-03-30-15-57-39-813.png!
>  
> Phoneix works from shell using sqlline.py script.
>  
> Can anybody help?



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Commented] (PHOENIX-6678) Dbeaver jdbc connetion for Phoenix

2022-03-31 Thread Dmitry Kravchuk (Jira)


[ 
https://issues.apache.org/jira/browse/PHOENIX-6678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17515583#comment-17515583
 ] 

Dmitry Kravchuk commented on PHOENIX-6678:
--

[~larsh] I tried to send email to the developer list address and it was 
unsuccessfull because email is invalid.

> Dbeaver jdbc connetion for Phoenix
> --
>
> Key: PHOENIX-6678
> URL: https://issues.apache.org/jira/browse/PHOENIX-6678
> Project: Phoenix
>  Issue Type: Bug
>  Components: connectors
>Affects Versions: 5.0.0
> Environment: Hbase 2.0.2
> Phoenix 5.0.0
>Reporter: Dmitry Kravchuk
>Priority: Major
> Attachments: image-2022-03-30-15-53-14-255.png, 
> image-2022-03-30-15-53-23-717.png, image-2022-03-30-15-55-19-706.png, 
> image-2022-03-30-15-56-42-691.png, image-2022-03-30-15-57-39-813.png, 
> image-2022-03-31-10-56-32-334.png, image-2022-03-31-10-57-11-856.png, 
> image-2022-03-31-10-57-26-287.png, image-2022-03-31-13-49-29-131.png, 
> image-2022-03-31-13-50-18-105.png, image-2022-03-31-13-50-45-594.png, 
> image-2022-03-31-13-51-07-925.png, image-2022-03-31-13-51-29-100.png
>
>
> I've been searching solution for successfull connection to Phoenix usig 
> DBeaven for a weeks and came here for help.
> Here is my HBase config:
> !image-2022-03-30-15-53-23-717.png!
> Here is my DBeaver connection properties:
> !image-2022-03-30-15-55-19-706.png!
> I've donwloaded phoenix and hbase jars from hadoop cluster as connection 
> drivers:
> !image-2022-03-30-15-56-42-691.png!
> Error:
> !image-2022-03-30-15-57-39-813.png!
>  
> Phoneix works from shell using sqlline.py script.
>  
> Can anybody help?



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Commented] (PHOENIX-6678) Dbeaver jdbc connetion for Phoenix

2022-03-31 Thread Dmitry Kravchuk (Jira)


[ 
https://issues.apache.org/jira/browse/PHOENIX-6678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17515234#comment-17515234
 ] 

Dmitry Kravchuk commented on PHOENIX-6678:
--

I've checked connetion with CLI:

!image-2022-03-31-13-49-29-131.png!

But with DBeaver I still got an error:

!image-2022-03-31-13-50-18-105.png!

!image-2022-03-31-13-50-45-594.png!

!image-2022-03-31-13-51-07-925.png!

!image-2022-03-31-13-51-29-100.png!

 

> Dbeaver jdbc connetion for Phoenix
> --
>
> Key: PHOENIX-6678
> URL: https://issues.apache.org/jira/browse/PHOENIX-6678
> Project: Phoenix
>  Issue Type: Bug
>  Components: connectors
>Affects Versions: 5.0.0
> Environment: Hbase 2.0.2
> Phoenix 5.0.0
>Reporter: Dmitry Kravchuk
>Priority: Major
> Attachments: image-2022-03-30-15-53-14-255.png, 
> image-2022-03-30-15-53-23-717.png, image-2022-03-30-15-55-19-706.png, 
> image-2022-03-30-15-56-42-691.png, image-2022-03-30-15-57-39-813.png, 
> image-2022-03-31-10-56-32-334.png, image-2022-03-31-10-57-11-856.png, 
> image-2022-03-31-10-57-26-287.png, image-2022-03-31-13-49-29-131.png, 
> image-2022-03-31-13-50-18-105.png, image-2022-03-31-13-50-45-594.png, 
> image-2022-03-31-13-51-07-925.png, image-2022-03-31-13-51-29-100.png
>
>
> I've been searching solution for successfull connection to Phoenix usig 
> DBeaven for a weeks and came here for help.
> Here is my HBase config:
> !image-2022-03-30-15-53-23-717.png!
> Here is my DBeaver connection properties:
> !image-2022-03-30-15-55-19-706.png!
> I've donwloaded phoenix and hbase jars from hadoop cluster as connection 
> drivers:
> !image-2022-03-30-15-56-42-691.png!
> Error:
> !image-2022-03-30-15-57-39-813.png!
>  
> Phoneix works from shell using sqlline.py script.
>  
> Can anybody help?



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Commented] (PHOENIX-6678) Dbeaver jdbc connetion for Phoenix

2022-03-31 Thread Istvan Toth (Jira)


[ 
https://issues.apache.org/jira/browse/PHOENIX-6678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17515160#comment-17515160
 ] 

Istvan Toth commented on PHOENIX-6678:
--

You need to add the directory containing hbase-site.xml to the classpath, not 
the file.

> Dbeaver jdbc connetion for Phoenix
> --
>
> Key: PHOENIX-6678
> URL: https://issues.apache.org/jira/browse/PHOENIX-6678
> Project: Phoenix
>  Issue Type: Bug
>  Components: connectors
>Affects Versions: 5.0.0
> Environment: Hbase 2.0.2
> Phoenix 5.0.0
>Reporter: Dmitry Kravchuk
>Priority: Major
> Attachments: image-2022-03-30-15-53-14-255.png, 
> image-2022-03-30-15-53-23-717.png, image-2022-03-30-15-55-19-706.png, 
> image-2022-03-30-15-56-42-691.png, image-2022-03-30-15-57-39-813.png, 
> image-2022-03-31-10-56-32-334.png, image-2022-03-31-10-57-11-856.png, 
> image-2022-03-31-10-57-26-287.png
>
>
> I've been searching solution for successfull connection to Phoenix usig 
> DBeaven for a weeks and came here for help.
> Here is my HBase config:
> !image-2022-03-30-15-53-23-717.png!
> Here is my DBeaver connection properties:
> !image-2022-03-30-15-55-19-706.png!
> I've donwloaded phoenix and hbase jars from hadoop cluster as connection 
> drivers:
> !image-2022-03-30-15-56-42-691.png!
> Error:
> !image-2022-03-30-15-57-39-813.png!
>  
> Phoneix works from shell using sqlline.py script.
>  
> Can anybody help?



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Commented] (PHOENIX-6678) Dbeaver jdbc connetion for Phoenix

2022-03-31 Thread Dmitry Kravchuk (Jira)


[ 
https://issues.apache.org/jira/browse/PHOENIX-6678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17515150#comment-17515150
 ] 

Dmitry Kravchuk commented on PHOENIX-6678:
--

Didn't help me either:

!image-2022-03-31-10-56-32-334.png!

!image-2022-03-31-10-57-11-856.png!

!image-2022-03-31-10-57-26-287.png!

> Dbeaver jdbc connetion for Phoenix
> --
>
> Key: PHOENIX-6678
> URL: https://issues.apache.org/jira/browse/PHOENIX-6678
> Project: Phoenix
>  Issue Type: Bug
>  Components: connectors
>Affects Versions: 5.0.0
> Environment: Hbase 2.0.2
> Phoenix 5.0.0
>Reporter: Dmitry Kravchuk
>Priority: Major
> Attachments: image-2022-03-30-15-53-14-255.png, 
> image-2022-03-30-15-53-23-717.png, image-2022-03-30-15-55-19-706.png, 
> image-2022-03-30-15-56-42-691.png, image-2022-03-30-15-57-39-813.png, 
> image-2022-03-31-10-56-32-334.png, image-2022-03-31-10-57-11-856.png, 
> image-2022-03-31-10-57-26-287.png
>
>
> I've been searching solution for successfull connection to Phoenix usig 
> DBeaven for a weeks and came here for help.
> Here is my HBase config:
> !image-2022-03-30-15-53-23-717.png!
> Here is my DBeaver connection properties:
> !image-2022-03-30-15-55-19-706.png!
> I've donwloaded phoenix and hbase jars from hadoop cluster as connection 
> drivers:
> !image-2022-03-30-15-56-42-691.png!
> Error:
> !image-2022-03-30-15-57-39-813.png!
>  
> Phoneix works from shell using sqlline.py script.
>  
> Can anybody help?



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Commented] (PHOENIX-6678) Dbeaver jdbc connetion for Phoenix

2022-03-31 Thread Istvan Toth (Jira)


[ 
https://issues.apache.org/jira/browse/PHOENIX-6678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17515131#comment-17515131
 ] 

Istvan Toth commented on PHOENIX-6678:
--

# do not add phoenix-server.jar to the classpath
 # You seem to be using a new style ZK quorum , which Phoenix 5.0.0 does not 
support. Specify the port only once, at the end. (host1,host2,host3:2181)

> Dbeaver jdbc connetion for Phoenix
> --
>
> Key: PHOENIX-6678
> URL: https://issues.apache.org/jira/browse/PHOENIX-6678
> Project: Phoenix
>  Issue Type: Bug
>  Components: connectors
>Affects Versions: 5.0.0
> Environment: Hbase 2.0.2
> Phoenix 5.0.0
>Reporter: Dmitry Kravchuk
>Priority: Major
> Attachments: image-2022-03-30-15-53-14-255.png, 
> image-2022-03-30-15-53-23-717.png, image-2022-03-30-15-55-19-706.png, 
> image-2022-03-30-15-56-42-691.png, image-2022-03-30-15-57-39-813.png
>
>
> I've been searching solution for successfull connection to Phoenix usig 
> DBeaven for a weeks and came here for help.
> Here is my HBase config:
> !image-2022-03-30-15-53-23-717.png!
> Here is my DBeaver connection properties:
> !image-2022-03-30-15-55-19-706.png!
> I've donwloaded phoenix and hbase jars from hadoop cluster as connection 
> drivers:
> !image-2022-03-30-15-56-42-691.png!
> Error:
> !image-2022-03-30-15-57-39-813.png!
>  
> Phoneix works from shell using sqlline.py script.
>  
> Can anybody help?



--
This message was sent by Atlassian Jira
(v8.20.1#820001)


[jira] [Commented] (PHOENIX-6678) Dbeaver jdbc connetion for Phoenix

2022-03-31 Thread Dmitry Kravchuk (Jira)


[ 
https://issues.apache.org/jira/browse/PHOENIX-6678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17515112#comment-17515112
 ] 

Dmitry Kravchuk commented on PHOENIX-6678:
--

Okay, I've sent an email with this issue.

> Dbeaver jdbc connetion for Phoenix
> --
>
> Key: PHOENIX-6678
> URL: https://issues.apache.org/jira/browse/PHOENIX-6678
> Project: Phoenix
>  Issue Type: Bug
>  Components: connectors
>Affects Versions: 5.0.0
> Environment: Hbase 2.0.2
> Phoenix 5.0.0
>Reporter: Dmitry Kravchuk
>Priority: Major
> Attachments: image-2022-03-30-15-53-14-255.png, 
> image-2022-03-30-15-53-23-717.png, image-2022-03-30-15-55-19-706.png, 
> image-2022-03-30-15-56-42-691.png, image-2022-03-30-15-57-39-813.png
>
>
> I've been searching solution for successfull connection to Phoenix usig 
> DBeaven for a weeks and came here for help.
> Here is my HBase config:
> !image-2022-03-30-15-53-23-717.png!
> Here is my DBeaver connection properties:
> !image-2022-03-30-15-55-19-706.png!
> I've donwloaded phoenix and hbase jars from hadoop cluster as connection 
> drivers:
> !image-2022-03-30-15-56-42-691.png!
> Error:
> !image-2022-03-30-15-57-39-813.png!
>  
> Phoneix works from shell using sqlline.py script.
>  
> Can anybody help?



--
This message was sent by Atlassian Jira
(v8.20.1#820001)