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

James Taylor commented on PHOENIX-5405:
---------------------------------------

I think passing data through a hint is a bad practice. Why not just open a new 
connection which is a very cheap operation - just instantiating a few objects 
since the underlying cluster connection is cached.

> Enable timerange in sql hint
> ----------------------------
>
>                 Key: PHOENIX-5405
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5405
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Chen Feng
>            Priority: Minor
>         Attachments: PHOENIX-5405-v1.patch, PHOENIX-5405-v2.patch, 
> PHOENIX-5405-v3.patch
>
>
> PHOENIX-914 enabled Native HBase timestamp support to optimize date range 
> queries in Phoenix.
> However, the end time is set at the beginning of connection. For a long term 
> connection, we cannot change SCN during processing.
> If we have knowledge of underly HBase timestamp, we can use a connection-free 
> way to query the target data by adding a hint in sql.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

Reply via email to