Skip to main content
-2 votes
0 answers
21 views

I'm working with IoT sensor data using DolphinDB's TSDB engine. The table structure is as follows (composite partitioned by date and device): schema = table( 1:0, `ts`device_id`plant`...
Allan's user avatar
  • 21
1 vote
1 answer
58 views

I am trying to fetch JSON data from an HTTP API and convert it into an in‑memory table in DolphinDB. The JSON response is an array of objects, and I want to store it as a table where each object ...
Gerard Kane's user avatar
-2 votes
0 answers
23 views

I'm working with IoT device sensor data. The table structure is as follows (TSDB engine, partitioned by date and device): // Sensor real-time data table db_date = database("", VALUE, 2024....
haru's user avatar
  • 27
0 votes
0 answers
19 views

I have two arrays ap and ap2, along with their corresponding value arrays av and av2. All four arrays have the same length. ap = 23 24 25 26 av = 10 20 30 40 ap2 = 24 25 26 27 av2 = 32 32 32 32 I ...
Lambert's user avatar
1 vote
0 answers
34 views

I'm working on equipment status management for a smart building project in DolphinDB, and I'm trying to figure out how to maintain real-time device status with stream tables. What can I try next? I'm ...
Jane's user avatar
  • 29
0 votes
0 answers
23 views

I'm having an issue with false alarms in my stream processing code for threshold monitoring, and I'd like some advice on optimization. Here's the scenario: A pH sensor at a wastewater treatment plant ...
Allan's user avatar
  • 21
1 vote
1 answer
69 views

I am developing a DolphinDB plugin and need to write data to either an in-memory table or a distributed table. In the plugin, I call the built-in function append! to perform the write, and I want to ...
Shiv Sharma's user avatar
0 votes
0 answers
31 views

I am developing a DolphinDB plugin for DuckDB and encountered an issue when reading data of type TIMESTAMP_NS. For example, I have an allTypes table in DuckDB. Executing the following statements: ...
Shiv Sharma's user avatar
0 votes
0 answers
51 views

I am working on a plugin to transfer data from DolphinDB to DuckDB. I have a test case that tries to append a table containing various DolphinDB types to DuckDB. The table includes a nanotimestamp ...
Shiv Sharma's user avatar
3 votes
1 answer
32 views

I'm working on a smart manufacturing project with 10 CNC machines, each reporting spindle temperature every 5 seconds. I want to monitor in real-time which machine has the fastest temperature rise ...
haru's user avatar
  • 27
0 votes
0 answers
18 views

I am using DolphinDB for real-time stream processing. The scenario is: There is a motor in the factory equipped with two sensors, one for temperature and one for vibration. Temperature is collected ...
Lambert's user avatar
-1 votes
1 answer
44 views

The scenario involves aggregating L1 tick data for individual stocks (approximately 5,200) into 1-minute candlestick data. The current data source continues to push data after key time points (such as ...
Jane's user avatar
  • 29
3 votes
1 answer
53 views

I am developing a DuckDB plugin for DolphinDB and have the following test case: @testing:case="test_duckdb_load_to_dfs_with_transform" -- A. Prepare DFS table dbPath = "dfs://...
Shiv Sharma's user avatar
0 votes
1 answer
42 views

I currently have an index matrix that I want to convert into a data table, and store the corresponding indices as fields in the data table. I tried using the table() function to achieve this, but when ...
haru's user avatar
  • 27
-2 votes
1 answer
86 views

I have three panel data tables A, B, and C with the following structure: Index: date Columns: stock codes (e.g., S1, S2, ...) Example structure of each table: date S1 S2 20100101 1 2 20100102 3 4 ...
Allan's user avatar
  • 21

15 30 50 per page
1
2 3 4 5
20