[ 
https://issues.apache.org/jira/browse/CALCITE-1291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated CALCITE-1291:
---------------------------------------------
    Fix Version/s: 1.9.0

> Incorrect formatting from Avatica in sqlline's table outputformat
> -----------------------------------------------------------------
>
>                 Key: CALCITE-1291
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1291
>             Project: Calcite
>          Issue Type: Bug
>          Components: avatica
>            Reporter: Josh Elser
>            Assignee: Josh Elser
>             Fix For: 1.9.0
>
>
> {noformat}
> 0: jdbc:phoenix:thin:url=http://localhost:876> select * from STR_VIEW;
> +------------------------------------------+------------------------------------------+--------------------------------+
> |                    PK                    |                   VAL            
>         |                LONG_VALUE      |
> +------------------------------------------+------------------------------------------+--------------------------------+
> | ASDFASDFASDFASDFASDFASDFASDFASDFASDFASDFASDFASDF | value1                   
>                 | valuevaluevaluevalueva |
> +------------------------------------------+------------------------------------------+--------------------------------+
> 1 row selected (0.025 seconds)
> {noformat}
> {noformat}
> 0: jdbc:phoenix:localhost:2181:/hbase-1.2> select * from STR_VIEW;
> +---------------------------------------------------+---------+-----------------------------------------------------+
> |                        PK                         |   VAL   |               
>       LONG_VALUE                      |
> +---------------------------------------------------+---------+-----------------------------------------------------+
> | ASDFASDFASDFASDFASDFASDFASDFASDFASDFASDFASDFASDF  | value1  | 
> valuevaluevaluevaluevaluevaluevaluevaluevaluevalue  |
> +---------------------------------------------------+---------+-----------------------------------------------------+
> 1 row selected (0.058 seconds)
> {noformat}
> This is the difference between using Apache Phoenix's avatica client and the 
> normal client and sqlline 1.1.9. With {{!outputformat table}} above, we can 
> see the difference in these two clients, while {{!outputformat xmlattr}} 
> shows the complete (and expected) values.
> It seems like some column metadata is just not being properly sent by PQS (at 
> least that's my hunch). The data is present in the results, just not rendered 
> properly. I'll have to look into what sqlline pulls for the column width and 
> figure out if PQS is sending that properly.



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

Reply via email to