[
https://issues.apache.org/jira/browse/CALCITE-2492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16611671#comment-16611671
]
Stamatis Zampetakis commented on CALCITE-2492:
----------------------------------------------
I am sorry but I do not understand the question. Can you please clarify a bit
further.
Do _start_time_ and _end_time_ correspond to columns of the table _tableName_?
If yes, then can't you use dynamic SQL parameters as follows:
{code:java}
SELECT * FROM tableName WHERE start_time = ? AND end_time = ?{code}
> is there any way to define dynamic parameters for table in query
> ----------------------------------------------------------------
>
> Key: CALCITE-2492
> URL: https://issues.apache.org/jira/browse/CALCITE-2492
> Project: Calcite
> Issue Type: New Feature
> Reporter: Wenlong Lyu
> Assignee: Julian Hyde
> Priority: Major
>
> Currently we are trying to implement a catalog and sql engine with calcite,
> which need to support define table representing all kinds of storage: message
> queue, db, etc. When try to query a table of message queue from catalog, we
> need to specify the range of data to scan，such like start_time/end_time,
> which is not supported in calcite。
> Is there a good way to solve a problem?
> Is it good to extend calcite with dynamic parameters like: {code} select *
> from tableName with (start_time='', end_time='') {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
