Can order by in Apache IoTDB order by fields in time series, instead of ordering by time or device? I want to find the utility data distribution of a certain device during a certain period of time, and now I can only query out all the data during this period and then order the utility data by myself. I wonder if there is an easier way for me to know the distribution of data?
How to order the data by physical fields in Apache IoTDB?
70 views Asked by tianyi zhang At
1
There are 1 answers
Related Questions in TIME-SERIES
- Measures of similarity for time series data
- Is there an algorithm to identify the increasing Period/Interval of a time series?
- What kind of ARIMA model would be best fit for this data?
- How to load very big timeseries file(s) in Python to do analysis?
- How to write the query statement of the total number of time series by paging in Apache IoTDB?
- error to generate regular raster stack time series in R
- Getting NotImplementedError: While Importing ARMA
- Plotting Non-Uniform Time Series Data from a Text File
- How in SQL can I identify if a value has changed within the current week or vis-a-vis the previous week?
- LSTM : predict_step in PyTorch Lightning
- Slow SELECT statement, possibly due to WHERE?
- R: Error in tseries::garch() Function for Auto GARCH Model Detection
- LSTM multistep forecast
- Sum column depending on values from another column on a single row (Pivot columns)
- gap fill for raster stack in R
Related Questions in APACHE-IOTDB
- How to prevent the previous deleted data to be restored by the database set in Apache IoTDB?
- After deleting the aligned time series in certain device, why did Apache IoTDB still reported "timeseries under this device are aligned" error?
- How to write the query statement of the total number of time series by paging in Apache IoTDB?
- How to delete the cluster datanode in unknown state in Apache IoTDB?
- How to manually trigger flush execution to clean the data under wal directory?
- How to migrate the data to different cluster in cluster version of Apache IoTDB?
- After copying data and system directories of datanode, why did the data still cannot be queried in the new server of Apache IoTDB?
- How to set the different ttl for different batches of time series data inserted into Apache IoTDB?
- What may be the reason of insertTablet failed reported in container and datanode logs of Apache IoTDB?
- Why Apache IoTDB created multiple dataRegions for the same database settings in short period of time?
- When querying in Apache IoTDB Version 0.13.3, why results are duplicated for crertain timestamp ranges?
- What configuration need to be changed for DataNode failed to startup and reported `internal TEndPoints can't be modified`?
- When changing ip settings from different network to migrate data in Apache IoTDB, why did the query statement reported error?
- Apache IoTDB deployed in k8s?
- How to delete not continuous data points in batches in Apache IoTDB?
Related Questions in IOTDB
- How to prevent the previous deleted data to be restored by the database set in Apache IoTDB?
- After deleting the aligned time series in certain device, why did Apache IoTDB still reported "timeseries under this device are aligned" error?
- How to write the query statement of the total number of time series by paging in Apache IoTDB?
- How to delete the cluster datanode in unknown state in Apache IoTDB?
- How to manually trigger flush execution to clean the data under wal directory?
- How to migrate the data to different cluster in cluster version of Apache IoTDB?
- After copying data and system directories of datanode, why did the data still cannot be queried in the new server of Apache IoTDB?
- How to set the different ttl for different batches of time series data inserted into Apache IoTDB?
- What may be the reason of insertTablet failed reported in container and datanode logs of Apache IoTDB?
- Why Apache IoTDB created multiple dataRegions for the same database settings in short period of time?
- When querying in Apache IoTDB Version 0.13.3, why results are duplicated for crertain timestamp ranges?
- What configuration need to be changed for DataNode failed to startup and reported `internal TEndPoints can't be modified`?
- When changing ip settings from different network to migrate data in Apache IoTDB, why did the query statement reported error?
- Apache IoTDB deployed in k8s?
- How to delete not continuous data points in batches in Apache IoTDB?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
If you want the distribution of data in Apache IoTDB, aside of using
maxandminfunctions, you can also useTop Kto get the corresponding quantile you want. Also, you can try to use aggregate functions to know more, or write a program to get the data fields.