[
https://issues.apache.org/jira/browse/PHOENIX-5405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16900851#comment-16900851
]
Lars Hofhansl commented on PHOENIX-5405:
----------------------------------------
(IMHO) It's not necessarily bad practice to use hints to express query
parameters that do not fit into any SQL paradigms. Creating a new connection
each time forces one to leave the realm of SQL into the Java host system, seems
clumsy.
Generally, I'm not a fan of hints, though, but prefer the system to optimize
automatically.
> 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)
