Recover/Reset Root Password?

Hello Is there a process to recover or reset the root user password? For example, if a customer forgets their root user password. Is it possible to replace the "root.profile" file under data/confignode/system/users with the default? Would this work? Thanks  Trevor Hart

Re: ALIGN BY DEVICE: the data types of the same measurement column should be the same across devices.

Ah that is great to hear! Thank you! Thanks  Trevor Hart On Wed, 12 Jun 2024 13:50:43 +1200 Jialin Qiao wrote --- Hi, We just changed the default infer type of integer and floating to DOUBLE [1], it will be released in 1.3.2. For <=1.3.1, you could explicitly set this

ALIGN BY DEVICE: the data types of the same measurement column should be the same across devices.

; is DOUBLE but that is not what I am seeing. Why am I getting FLOAT? Is the default "floating_string_infer_type" not being honoured? Currently in the config file "floating_string_infer_type" is commented out. Should I explicitly set this to DOUBLE? Thanks  Trevor Hart

Re: Upgrading 0.12 -> 1.3

Thank you Jialin. I didnt realise the data was not migrated as part of the upgrade. That is good to see there is a resource to migrate. I will use that approach. Thanks  Trevor Hart On Tue, 28 May 2024 13:35:41 +1200 Jialin Qiao wrote --- Hi, The architecture of 1.x is

Upgrading 0.12 -> 1.3

ate this data I am proposing this process; 1. Use "select into" to migrate to a new path ie root.ABC.health.url.17.code ->  root.ABC.health.url.U17.code 2. Delete the old timeseries ie root.ABC.health.url.17.code 3. Upgrade IoTDB Is this the correct/best approach? Thanks  Trevor Hart

Windows Installer

Node 3. Open port 6667 on Windows firewall You can see the installer in action here;  https://www.youtube.com/watch?v=6BzCd-vAiGc&t=1s&ab_channel=OpeLtd If there is any interest in this I can make it available. Thanks Trevor Hart

Re: Handling Duplicate Timestamps

IoTDB so I can enforce PK validation there. That way it is less expensive that checking the timestamp in IoTDB for each record. Thanks  Trevor Hart On Fri, 17 May 2024 19:11:13 +1200 Jialin Qiao wrote --- Hi Trevor, Will different values of the same timestamp be the same

Re: [DISCUSS] Drop Java 8?

does not require a license. Thanks  Trevor Hart On Fri, 17 May 2024 13:30:15 +1200 Yuan Tian wrote --- Hi Chris, It seems that a lot of people still use jdk1.8 in their product environment. Best regards, - Yuan Tian On Thu, May 16, 2024 at 8:10 PM

Re: Handling Duplicate Timestamps

Thank you! I will implment some work around for now. I would appreciate some consideration for this option in the future. Thanks  Trevor Hart Ope Limited w: http://www.ope.nz/ m: +64212728039 On Tue, 14 May 2024 15:17:47 +1200 Xiangdong Huang wrote --- > 1. Check

Re: Handling Duplicate Timestamps

introducing some insignificant time value to keep timestamp values unique. I have already done something similar to #2 with storing IIS web log files as they are recorded in seconds and not milliseconds. Thanks  Trevor Hart On Tue, 14 May 2024 13:29:02 +1200 Yuan Tian wrote --- Hi

Re: Handling Duplicate Timestamps

there is a chance that there could be colliding time stamps.As it stands now I would need to check if the timestamp exists before inserting the data. Which obviously affects throughput.  Thanks Trevor Hart On Fri, 10 May 2024 00:33:40 +1200 Jialin Qiao wrote Hi, In IoT or IIoT

Handling Duplicate Timestamps

than lose data. I read through the documentation but couldn’t find anything.  Thanks  Trevor Hart

Test

Just testing, my last two messages have not been published. Thanks  Trevor Hart

Handling Duplicate Timestamps

lose data. I read through the documentation but couldn’t find anything.  Thanks  Trevor Hart

Re: Fw:dbeaver操作异常

HelloI am also using DBeaver. While it is very handy I have found like you there are certain statements that it does not process. I have posted before about a Java based UI that I developed. If you are interested I can give you the details. Thanks Trevor Hart

Duplicate timestamps

the situation rather than lose data.I read through the documentation but couldn’t find anything. Thanks Trevor Hart

Re: New Table Model for IoTDB

Can you clarify whether the old tree model exists in parallel?I can see the table being useful when querying one device but I hope we can still use the old model as well. Thanks Trevor Hart On Sun, 07 Apr 2024 23:39:02 +1200 Yuan Tian wrote Hi all

Re: Get Full Row Count?

Thank you Yuan, that works! Thanks  Trevor Hart On Thu, 04 Apr 2024 14:10:43 +1300 Yuan Tian wrote --- Hi Trevor, Maybe you can try count_time agg function, https://iotdb.apache.org/UserGuide/latest/Reference/Function-and-Expression.html#count-time . select count_time

Re: [DISCUSS] Make enabling "fat-jars" the default for the JDBC module?

I would love this. I currently use a batch file to build a fat jar (just for JDBC). Thanks  Trevor Hart On Wed, 03 Apr 2024 00:42:40 +1300 Christofer Dutz wrote --- Hi all, so right now, I keep on having the issue, that I keep on needing to re-build IoTDB, as I forgot

Get Full Row Count?

(time) from root.logs.device and select count(timestamp) from root.logs.device Thanks  Trevor Hart

Re: Inquiry Regarding Key Column Creation for IoTDB

Would it not be better to utilise the hierarchy in IoTDB? This saves space and means no need for a key So root.vehicles.CAR1 root.vehicles.CAR2 root.vehicles.CAR3 And then under each CAR store lat, long, speed etc You can still query all of the data  select * from root.vehicles.*

Re: What are all the empty "ext" directories for?

Not sure what all of them are but UDF is where you put custom data functions (jar files). Im guessing the same for triggers? Thanks  Trevor Hart Ope Limited w: http://www.ope.nz/ m: +64212728039 On Thu, 13 Jul 2023 00:45:40 +1200 Christofer Dutz wrote --- Hi, so

Re: Building the jdbc-diver as a fat-jar?

100% agree. I have been building my own fat jar version for the past few years. Thanks Trevor HartOpe Limitedw: www.ope.nzm: +64212728039 On Wed, 05 Jul 2023 06:07:39 +1200 Christofer Dutz wrote Hi all, today I wanted to play around with the 1.3.0-

Re: Remove UserGuide before 0.13 from website

+1 for having an archive available. I still use these docs and I am using 0.12. Thanks  Trevor Hart Ope Limited w: http://www.ope.nz/ m: +64212728039 On Fri, 24 Feb 2023 06:10:08 +1300 Xiangdong Huang wrote --- I think it is ok to remove old docs out of the source repo

Re: [ANNOUNCE] Apache IoTDB 1.0.0 released

Amazing work team! Very excited! Thanks  Trevor Hart On Tue, 06 Dec 2022 03:28:49 +1300 Jialin Qiao wrote --- Congratulations! — Jialin Qiao Apache IoTDB PMC

Re: TsFile golden data

ints. Parquet works fine in this case, but if we can proof  that this format is better in term of space, memory consumption, query performance,etc, we won the lottery :) Best Regards, Giorgio Il giorno dom 14 ago 2022 alle ore 21:37 Trevor Hart <mailt

Re: TsFile golden data

What version are you looking for? Will V12 be okay? Thanks  Trevor On Sun, 14 Aug 2022 19:45:24 +1200 Giorgio Zoppi wrote --- Hello IOTDBers, i am looking for a last version Tsfile with real or somewhat real data for testing purposes. Is there anyone has to share such a file

Re: [DISCUSSION] The name of a UDF

In Windows OS that kind of action is referred to as "deduplication" or dedup. Thanks  Trevor Hart Ope Limited w: http://www.ope.nz/ m: +64212728039 On Wed, 03 Aug 2022 01:47:08 +1200 Jialin Qiao wrote --- Hi, change_points may be a good option. Refe

JDBC vs Java API

sing  session.executeNonQueryStatement. I assume insertTablets and insertRecord(s) would be even faster? Thanks Trevor Hart

Re: [DISCUSS] Release IoTDB v0.12.5

+1 Thanks Trevor HartOpe Limitedw: www.ope.nzm: +64212728039 On Fri, 18 Feb 2022 16:01:48 +1300 HW-Chao Wang<576749...@qq.com.INVALID> wrote good,we can release new version, and resolved some bug fixes. ---Original--- From: "Steve Su"

Re: New feature - The ability of nesting expressions in an aggregation query

Thank you so much! Ive been after this for a while now! Very excited. Thanks  Trevor Hart Ope Limited w: http://www.ope.nz/ m: +64212728039 On Mon, 13 Dec 2021 22:19:29 +1300 Eric Pai wrote Dear all, A new feature, the ability of nesting expressions outside

Re: iotdbUI - GUI for executing queries

Hi Here is a mac OS zip with the correct Open JDK 11 + JFX runtime.   https://ope.nz/public/iotdbUI_macos.zip Thanks  Trevor Hart Ope Limited w: http://www.ope.nz/ m: +64212728039 On Thu, 25 Nov 2021 16:23:07 +1300 Xiangdong Huang wrote Hi Trevor, Thanks, I

iotdbUI - GUI for executing queries

.\runtime\java\javafx\lib --add-modules ALL-MODULE-PATH -jar iotdbUI.jar 3. if you are on Windows you can use the included executable that runs the above command (it expects included bundled runtime). Any feedback is welcome. Thanks  Trevor Hart

Re: IoTDB-quality applying for subproject

Great news as I would love to contribute to it! Thanks  Trevor On Thu, 25 Nov 2021 15:15:03 +1300 陈 鹏宇 wrote Hi everyone, I'm on behalf of IoTDB-quality developers. We have recently decided to make our project open source, and formally apply it for a subproject of Apache I

Re: New UDTF iotDBExtras

apache.org> wrote Hi, Digital time looks more intuitive. Besides, could we rename the column from time to count in UDF? @mailto:mailto:steveyuron...@qq.com.invalid <mailto:mailto:steveyuron...@qq.com.invalid> Thanks, — Jialin Qiao Trevor Hart <mailto:mailto:tre..

Re: New UDTF iotDBExtras

intuitive. Besides, could we rename the column from time to count in UDF? @mailto:steveyuron...@qq.com.invalid <mailto:steveyuron...@qq.com.invalid> Thanks, — Jialin Qiao Trevor Hart <mailto:tre...@ope.nz> 于2021年11月2日周二 上午6:09写道： > I have put my first UDTF on

New UDTF iotDBExtras

  9|    24.12| |  16|    24.87| ++-+ Thanks  Trevor Hart Ope Limited w: http://www.ope.nz/ m: +64212728039

Re: Upgrading to 0.12 & iotdb-engine.properties

Thanks Yuan! On Fri, 29 Oct 2021 08:48:57 +1300 Trevor Hart wrote Hello Team I am finally upgrading to v0.12. I noticed that the new iotdb-engine.properties file has almost all options commented out (while my v0.11 does not). Is this okay to leave commented out

Upgrading to 0.12 & iotdb-engine.properties

Hello Team I am finally upgrading to v0.12. I noticed that the new iotdb-engine.properties file has almost all options commented out (while my v0.11 does not). Is this okay to leave commented out unless I specifically changed a setting in v0.11? Thanks  Trevor

Where clause with wildcard?

I have this query that works. select count(method) from root.org.logs.ags.ABC.device01 where method <> 'job' group by ([now()-1W,now()),1H) However if I introduce a wildcard all the results are zero. There is no error but all values are zero. Is this expected? If so is there any way to f

ApacheCon & iotDB

Good news everyone, I put in a submission for ApacheCon in the IOT stream which has been accepted. I will be presenting how I moved an application from using a traditional RDBMS to IotDB. Very excited! Thanks  Trevor Hart

Re: [Discussion] The aggregation function name of getting extreme value

My vote is for #3 or "EXT_VALUE" to be consistent with "MAX_VALUE" etc Thanks  Trevor Hart Ope Limited w: http://www.ope.nz/ On Wed, 02 Jun 2021 14:50:25 +1200 Xiangwei Wei wrote Hi guys, We plan to add a new aggregation function, whose fun

Re: High CPU Usage

Just reporting back on this topic again. The server has been up ~11 days now and CPU is still sitting around 4% constantly. Very happy with that! Thanks  Trevor Hart

Re: Please submit your talks to the ApacheCons early

Hi Chris, Do you have a link to the submission page for requirements etc? Thanks  Trevor Hart On Thu, 15 Apr 2021 23:21:49 +1200 Christofer Dutz wrote Hi IoTDb folks, As the chair of the IoT Track for the NA/EU ApacheCon and Co-Chair of the Asia, I regularly review

Re: High CPU Usage

0.11.3 RC3 seems much happier so far. There was an initial spike in CPU after I upgradef to 11.3 but it has now settled down.I will keep an eye on it over the next week - see attachment. Thanks Trevor Hart On Sat, 10 Apr 2021 15:45:36 +1200 tre...@ope.nz wrote Thanks everyone for the

Re: High CPU Usage

Thanks everyone for the replies, I have deployed 0.11.3 RC3. I will try that before I try altering the level compaction. Thanks  Trevor Hart On Fri, 09 Apr 2021 23:29:07 +1200 Xiangdong Huang wrote And remember to set the strategy back after diagnosis

High CPU Usage

Hi Team, I am still struggling with high CPU usage on V11.2. My CPU usage creeps up after a few days and basically got to 100% today and was unusable. If I restart the iotDB server then its fine for a few days. This Linux server has 2 cores and 4Gb RAM. The database is running 24x7. The

Re: start to release v0.11.3 RC2 and v0.12 RC1

+1 me too, very excited for v0.12Thanks Trevor On Thu, 01 Apr 2021 20:08:27 +1300 neuyi...@163.com wrote +1, Looking forward to the release of v0.12.Thanks,---Houliang QiBONC, LtdOn 04/1/2021 15:03，Yuxiang Song<1063877...@qq.com> wrote：+1， look for

Re: Considering releasing 0.11.3?

Great news. Thanks  Trevor On Tue, 16 Mar 2021 13:58:22 +1300 Xiangdong Huang wrote Hi all, As all Opened PRs labeled with 0.11 are merged, I will begin to release 0.11.3 today. Best, --- Xiangdong Huang School of Software, Tsinghua

Re: Percentile?

0Function.html > > Thanks, > -- > Jialin Qiao > School of Software, Tsinghua University > > 乔嘉林 > 清华大学 软件学院 > > -原始邮件- > *发件人:*"Trevor Hart" > *发送时间:*2021-03-12 17:10:05 (星期五) > *收件人:* dev > *抄送:* > *主题:* Percentile? > > Hello, > &g

Percentile?

Hello, I'm trying to determine percentile values from sensor values. In a normal RDBM this can be achieved by sorting sensor values and then using OFFSET and LIMIT to determine the 90th percentile etc. However in iotDB we cant sort by sensor values Is sorting by a value other than time