TDengine is an open-sourced big data platform under GNU AGPL v3.0, designed and optimized for the Internet of Things (IoT), Connected Cars, Industrial IoT, and IT Infrastructure and Application Monitoring.
Questions tagged [tdengine]
345 questions
0
votes
1 answer
TDengine sql optimization
Are there some who has experience of optimizing taos sql.
I'm in a situation bellow. I queried one days's trace info from history trace log. Nearly queried 10 million rows from 100 million rows among 10 days.I spent 40 minutes.my sql is…
Ray Shown
- 33
- 6
0
votes
1 answer
TDengine database nodejs connector millisecond precision
I want to retrieve data from TDengine database using nodejs connector.
const taos = require('td2.0-connector');
var host = "127.0.0.1";
var port = 6030;
var conn = taos.connect({host: host, user: "root", password: "taosdata", port: port});
var…
Jackson
- 9
- 4
0
votes
1 answer
TDengine database filtering a query by timestamp
From the screenshot, as you can see, there is data in my table t1. And I want to filter the query with the same timestamp in t1, but there is no result.
Jackson
- 9
- 4
0
votes
1 answer
How to set the number of replicas properly when I try to start a TDengine cluster?
I was wondering how to set the replica parameter properly when start a TDengine cluster to balance the storage and high availability? According to documentation of TDengine, default value of replica is 1 which means no copies for each vnode (vGroup…
naissance
- 36
- 12
0
votes
1 answer
How to use JDBC to connect TDengine database?
Not sure how to use JDBC connecter with TDengine database. I tried to look for the demo from the official documentation but there is no link with that "Java Connector(JDBC)"
Jackson
- 9
- 4
0
votes
1 answer
TDengine Question about stopping a TDengine query
I was running queries through TDengine's python connectors and encountered some queries that runs over 10 minutes. Is there a way to stop these queries?
Through show queries, I can see the running query, but I cannot execute kill queries to…
Feng Bryant
- 29
- 4
0
votes
2 answers
insert data error to TDengine when using RESTful
When I use RESTful API to insert data to my TDengine server, sometimes it reported 'Database not specified or available' error. Seems its behavior is not consistent so I'm confused why it happened. Am I alone?
TIA if someone can help out.
NCHAR(6)…
hook capt
- 135
- 5
0
votes
1 answer
How to adjust parameters in TDengine database?
When I use "show databases" command in taos shell, I see there are a lot of database parameters, like keep, days, cache, blocks
taos> show databases;
name | created_time | ntables | vgroups | replica |…
Alex
- 109
- 6
0
votes
1 answer
Why does TDengine consume so much less storage space compared with TimescaleDB?
For the past few days, I have inserted around 80 million rows of data into TDengine, and it turns out the storage only consumes around 1GB. Compared with TimescaleDB's storage usage, TDengine only uses around 1/15 of TimescaleDB's storage space. For…
Feng Bryant
- 29
- 4
0
votes
2 answers
TDengine import from csv file
Just found the speed for importing sorted csv file is faster than the speed for importing unsorted csv file in TDengine database, each csv file has 1000000 rows, the only difference is one file has timestamp sorted, the other has timestamp…
Alex
- 109
- 6
0
votes
2 answers
getting value from a pointer which point to double data and assign to a variable led system hang on ARM32 platform
The strange issue happens on the ARM32 platform. I need to run a time-series database to store and process my sensor data on an edge device. I don't have many options as some popular databases can't run on a device with very small storage…
hook capt
- 135
- 5
0
votes
1 answer
TDengine insertion use taos_stmt apis
After creating super table and tables, call taos_load_table_info to load the table information. Then initialize stmt by calling taos_stmt_init and taos_stmt_set_tbname to set up table name.
Create the TAOS_BIND object with the following attributes:…
Jackson
- 9
- 4
0
votes
1 answer
How to check query status on TDengine?
I was using TDengine to deploy a cluster of multiple nodes. After i
have created ~10000 tables and trying to execute a complex sql like below on one of my host it took quite some time for the query to finish. I'm wondering is there a way to check…
GeorgeWill93
- 167
- 5
-1
votes
1 answer
How to migrate TDengine data?
How to migrate TDengine2.X version data to 3.X, A direct update doesn't seem to work。
My TDengine version is 2.6.0.22, The data volume is 1TB。
I want to upgrade TDengine to 3.0.5.1。
Whether to directly upgrade the version of the upgrade tool？
If…
-1
votes
1 answer
TDEngine database backup
Do you need to create the corresponding database and tables in advance when importing the database backup Taosdump, or will it be automatically created based on the exported databaseMay I ask, what is the maximum number of CSV imports that Taos can…
Sun Hong
- 1