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

Kaide Mu commented on PHOENIX-2228:
-----------------------------------

Hi, [~rajeshbabu], I created the following SqlCreateSequence operator and added 
switch case for PhoenixPrepareImpl. Also I integrated 
SequenceIT.testCreateSequence() in CalciteIT which seems runs correctly (even 
though I didn't write parse logic). Now I'm trying to write SqlCreateSequence 
method in SqlParserImpl, but I cannot find SqlParserImpl in git.
{code:java}
// import statements
public class SqlCreateSequence extends SqlCall {
    public static final SqlOperator OPERATOR = new SqlDdlOperator("CREATE 
SEQUENCE", SqlKind.CREATE_SEQUENCE);

    public final SqlIdentifier sequenceName;
    public final SqlNode startWith;
    public final SqlNode incrementBy;
    public final SqlNode cacheSize;
    public final SqlNode minValue;
    public final SqlNode maxValue;
    public final SqlNode cycle;
    public final SqlNode ifNotExists;

    public SqlCreateSequence(SqlParserPos pos,
                             SqlIdentifier sequenceName,
                             SqlLiteral ifNotExists,
                             SqlNode startWith,
                             SqlNode incrementBy,
                             SqlNode minValue,
                             SqlNode maxValue,
                             SqlLiteral cycle,
                             SqlNode cacheSize
                             ) {
        super(pos);
        this.sequenceName = sequenceName;
        this.ifNotExists = ifNotExists;
        this.startWith = startWith;
        this.minValue = minValue;
        this.maxValue = maxValue;
        this.incrementBy = incrementBy;
        this.cycle = cycle;
        this.cacheSize = cacheSize;
    }

    public SqlOperator getOperator() {
        return OPERATOR;
    }

    public List<SqlNode> getOperandList() {
        return ImmutableList.of(sequenceName, ifNotExists, startWith, 
incrementBy, minValue, maxValue, cycle, cacheSize);
    }

    @Override
    public void unparse(SqlWriter writer, int leftPrec, int rightPrec) {
        //todo
    }
}
{code}

> Support CREATE TABLE in Phoenix-Calcite Integration
> ---------------------------------------------------
>
>                 Key: PHOENIX-2228
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2228
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Maryann Xue
>            Assignee: Rajeshbabu Chintaguntla
>              Labels: calcite
>         Attachments: PHOENIX-2228-wip.patch
>
>




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

Reply via email to