phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-1733) sqlline.py doesn't allow connecting with a tenant-specific connection
Date Sat, 18 Apr 2015 00:40:00 GMT

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

ASF GitHub Bot commented on PHOENIX-1733:
-----------------------------------------

Github user abisek commented on the pull request:

    https://github.com/apache/phoenix/pull/69#issuecomment-94106504
  
    Verified on Windows as well:
    ```
    C:\Phoenix\phoenix\bin>python sqlline.py asreeniva-wsl2.internal.salesforce.com:2181:/hbase;TenantId=t1
    Setting property: [isolation, TRANSACTION_READ_COMMITTED]
    issuing: !connect jdbc:phoenix:asreeniva-wsl2.internal.salesforce.com:2181:/hbase;TenantId=t1
none none org.apache.phoenix.jdbc.PhoenixDriver
    Connecting to jdbc:phoenix:asreeniva-wsl2.internal.salesforce.com:2181:/hbase;TenantId=t1
    ...
    ```



> sqlline.py doesn't allow connecting with a tenant-specific connection
> ---------------------------------------------------------------------
>
>                 Key: PHOENIX-1733
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1733
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Gabriel Reid
>            Assignee: Abhishek Sreenivasa
>              Labels: Newbie
>
> Connecting with a client-specific connection via sqlline.py should work with a command
like the following:
> {code}
> ./bin/sqlline.py 'localhost:2181;TenantId=t1'
> {code}
> However, the command that is built up within sqlline.py doesn't correctly quote the JDBC
url, so the JDBC url parameter ends up as:
> {code}
> jdbc:phoenix:localhost:2181;TenantId=t1
> {code}
> without quoting. This causes the semicolon to be interpreted as a command separator by
the shell, effectively ignoring it (and any other parameters).
> Proper parameter quoting (as done with the pipes module in psql.py) should be used for
sqlline.py to get around this and similar issues.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message