apache / apache/iotdb

[v0.12.2] Error when trying to create continuous query

Open
#4,325 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.4k
Forks
1.2k
Avg merge
1d 23h
Merged PRs (30d)
115

Description

**Describe the bug**

Today I wanted to create a continuous query, so I gave it a run. Already when running the first query I got from the documentation I got an error - and whatever I wrote, I got the same error:

```
Msg: 401: Error occurred while parsing SQL to physical plan: line 1:7 no viable alternative at input 'CREATE CONTINUOUS'
```

**To Reproduce**
Steps to reproduce the behavior:
1. Open a client to the iot-db
2. Run a query like `CREATE CONTINUOUS QUERY test BEGIN SELECT foo INTO test FROM root GROUP BY time(10s) END`
4. See error

**Expected behavior**

Create a continuous query of some kind ...

**Desktop (please complete the following information):**
- OS: Linux
- Browser n/a
- Version 0.12.2

**Additional context**

Here's a link to the documentation: https://iotdb.apache.org/UserGuide/Master/Advanced-Features/Continuous-Query.html

Contributor guide

Open the contributing guide

Research direction

Start by checking the linked continuous-query documentation and reproducing the exact CREATE CONTINUOUS QUERY example against IoTDB 0.12.2. Determine whether that documented query is supported in the reported version; done means the example no longer produces the parser error or the supported syntax and version are clearly identified.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.