[jira] [Commented] (CALCITE-2492) is there any way to define dynamic parameters for table in query

["Stamatis Zampetakis (JIRA)" <ji...@apache.org>]

    [ 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)