Re: The problem to start IoTDB

[Xiangdong Huang]

Hm.. After reading the codes carefully, I think the script is correct,
though it is better to name the variable `IOTDB_HOME` to `IOTDB_CLI_HOME`..

It is quite strange. Jack, can you try to run `mvn clean` and then compile
the project again to make sure that you can reproduce the issue?

---
Xiangdong Huang
School of Software, Tsinghua University

 黄向东
清华大学 软件学院


Xiangdong Huang  于2019年5月25日周六 下午12:49写道：

> Hi XuYi,
>
> At least I think there is something wrong in the start-cli.sh, please read
> the following code snippet in start-cli.sh:
>
> ```
> CLASSPATH=""
> for f in ${IOTDB_HOME}/lib/*.jar; do
>   CLASSPATH=${CLASSPATH}":"$f
> done
> ```
>
> If I am a user and I just run the cli on my laptop to connect an IoTDB
> Server, I think I do not need to install IoTDB module, so there is no jars
> in `${IOTDB_HOME}/lib`.
>
> Best,
> ---
> Xiangdong Huang
> School of Software, Tsinghua University
>
>  黄向东
> 清华大学 软件学院
>
>
> Jack Tsai  于2019年5月25日周六 上午1:54写道：
>
>> Hi XuYi,
>>
>> I have attached the screenshots of my operation in the JIRA issue. Please
>> have a look. If I have done something wrong, please welcome to tell me.
>>
>> Best regards,
>> Tsung Han Tsai
>> 
>> 寄件者: 徐毅 
>> 寄件日期: 2019年5月24日 下午 11:45
>> 收件者: dev@iotdb.apache.org
>> 主旨: Re: The problem to start IoTDB
>>
>> Hi,   Jack Tsai
>>
>>
>> I'm afraid you misunderstand the meaning of 'IOTDB_CLI_HOME'. It just
>> help users to find which directory to run command like '
>> .\bin\start-client.bat'. I never defined 'IOTDB_CLI_HOME' variable neither
>> in start-client.sh nor start-client.bat.
>>
>>
>> I tried on My PC, it starts normally. Can you provide some snapshots to
>> indicate how you package iotdb-cli and how to run start-client.bat? You can
>> upload these picture to jira issue.
>>
>>
>> 
>> In My environment, IOTDB_CLI_HOME is
>> D:\workspace\java\incubator-iotdb\iotdb-cli\cli
>> My output is :
>>
>>
>> PS D:\workspace\java\incubator-iotdb\iotdb-cli\cli> .\bin\start-client.bat
>> 
>> Starting IoTDB Client
>> 
>> Require more params input, eg. ./start-client.sh(start-client.bat if
>> Windows) -h xxx.xxx.xxx.xxx -p  -u xxx.
>> For more information, please check the following hint.
>> usage: ./start-client.sh(start-client.bat if Windows) [-disableISO8601]
>> [-h ]
>>[-help] [-maxPRC ] [-p ] [-pw ]
>> -u 
>>  -disableISO8601  Display timestamp in number(optional)
>>  -h Host Name (optional, default 127.0.0.1)
>>  -helpDisplay help information(optional)
>>  -maxPRCMaximum number of rows displayed (optional)
>>  -p Port (optional, default 6667)
>>  -pwpassword (optional)
>>  -u User name (required)
>> PS D:\workspace\java\incubator-iotdb\iotdb-cli\cli>
>>
>>
>> Thanks
>> XuYi
>>
>>
>> On 5/24/2019 09:05，Xiangdong Huang wrote：
>> Hi,
>>
>> Thank you for your contribution!
>>
>> The community is open for everyone, so take it easy... And we are happy to
>> see new contributors joining the community.
>>
>> Here, you can submit everything, like an issues, a new requirement, an
>> improvement, etc., to the mail list or jira for IoTDB.
>>
>> Best,
>> ---
>> Xiangdong Huang
>> School of Software, Tsinghua University
>>
>> 黄向东
>> 清华大学 软件学院
>>
>>
>> Jack Tsai  于2019年5月24日周五 上午6:46写道：
>>
>> Hi sir,
>>
>> I have created an issue for this:
>> https://issues.apache.org/jira/browse/IOTDB-94
>>
>> Please have a look at it. If there is anything wrong with the format of
>> the issue report or any inappropriate expression in my words. Please tell
>> me so that I could fixed it and avoid making the same mistake next time.
>>
>> Also, I provide the possible solution which I think it could solve this
>> problem in the comment field below. Please welcome to discuss with me to
>> let me know whether it is feasible. If it is alright, I would send the PR
>> for you to review.
>>
>> I am glad and looking forward to join the IoTDB team.
>>
>> Best regards,
>> Tsung-Han Tsai
>> --
>> *寄件者:* Xiangdong Huang 
>> *寄件日期:* 2019年5月24日 上午 12:25
>> *收件者:* dev@iotdb.apache.org; jack870...@outlook.com
>> *主旨:* Re: The problem to start IoTDB
>>
>> Hi Tsung-Han,
>>
>> Thanks for your report.
>>
>> I can not reproduce your issue on my MacOS..  The similar report on [1]
>> may be caused if your maven building process is interrupted.
>>
>> But after reading the source code of `start-client.sh`, I think your
>> solution 2 is needed: Now, `start-client.sh` requires copying jars from
>> the
>> `iotdb` module rather than just from the `iotdb-cli` module. That does not
>> make sense.
>>
>> We are very glad to see the coming PR from you.
>>
>> [1] 

Re: The problem to start IoTDB

[Xiangdong Huang]

Hi XuYi,

At least I think there is something wrong in the start-cli.sh, please read
the following code snippet in start-cli.sh:

```
CLASSPATH=""
for f in ${IOTDB_HOME}/lib/*.jar; do
  CLASSPATH=${CLASSPATH}":"$f
done
```

If I am a user and I just run the cli on my laptop to connect an IoTDB
Server, I think I do not need to install IoTDB module, so there is no jars
in `${IOTDB_HOME}/lib`.

Best,
---
Xiangdong Huang
School of Software, Tsinghua University

 黄向东
清华大学 软件学院


Jack Tsai  于2019年5月25日周六 上午1:54写道：

> Hi XuYi,
>
> I have attached the screenshots of my operation in the JIRA issue. Please
> have a look. If I have done something wrong, please welcome to tell me.
>
> Best regards,
> Tsung Han Tsai
> 
> 寄件者: 徐毅 
> 寄件日期: 2019年5月24日 下午 11:45
> 收件者: dev@iotdb.apache.org
> 主旨: Re: The problem to start IoTDB
>
> Hi,   Jack Tsai
>
>
> I'm afraid you misunderstand the meaning of 'IOTDB_CLI_HOME'. It just help
> users to find which directory to run command like '
> .\bin\start-client.bat'. I never defined 'IOTDB_CLI_HOME' variable neither
> in start-client.sh nor start-client.bat.
>
>
> I tried on My PC, it starts normally. Can you provide some snapshots to
> indicate how you package iotdb-cli and how to run start-client.bat? You can
> upload these picture to jira issue.
>
>
> 
> In My environment, IOTDB_CLI_HOME is
> D:\workspace\java\incubator-iotdb\iotdb-cli\cli
> My output is :
>
>
> PS D:\workspace\java\incubator-iotdb\iotdb-cli\cli> .\bin\start-client.bat
> 
> Starting IoTDB Client
> 
> Require more params input, eg. ./start-client.sh(start-client.bat if
> Windows) -h xxx.xxx.xxx.xxx -p  -u xxx.
> For more information, please check the following hint.
> usage: ./start-client.sh(start-client.bat if Windows) [-disableISO8601]
> [-h ]
>[-help] [-maxPRC ] [-p ] [-pw ]
> -u 
>  -disableISO8601  Display timestamp in number(optional)
>  -h Host Name (optional, default 127.0.0.1)
>  -helpDisplay help information(optional)
>  -maxPRCMaximum number of rows displayed (optional)
>  -p Port (optional, default 6667)
>  -pwpassword (optional)
>  -u User name (required)
> PS D:\workspace\java\incubator-iotdb\iotdb-cli\cli>
>
>
> Thanks
> XuYi
>
>
> On 5/24/2019 09:05，Xiangdong Huang wrote：
> Hi,
>
> Thank you for your contribution!
>
> The community is open for everyone, so take it easy... And we are happy to
> see new contributors joining the community.
>
> Here, you can submit everything, like an issues, a new requirement, an
> improvement, etc., to the mail list or jira for IoTDB.
>
> Best,
> ---
> Xiangdong Huang
> School of Software, Tsinghua University
>
> 黄向东
> 清华大学 软件学院
>
>
> Jack Tsai  于2019年5月24日周五 上午6:46写道：
>
> Hi sir,
>
> I have created an issue for this:
> https://issues.apache.org/jira/browse/IOTDB-94
>
> Please have a look at it. If there is anything wrong with the format of
> the issue report or any inappropriate expression in my words. Please tell
> me so that I could fixed it and avoid making the same mistake next time.
>
> Also, I provide the possible solution which I think it could solve this
> problem in the comment field below. Please welcome to discuss with me to
> let me know whether it is feasible. If it is alright, I would send the PR
> for you to review.
>
> I am glad and looking forward to join the IoTDB team.
>
> Best regards,
> Tsung-Han Tsai
> --
> *寄件者:* Xiangdong Huang 
> *寄件日期:* 2019年5月24日 上午 12:25
> *收件者:* dev@iotdb.apache.org; jack870...@outlook.com
> *主旨:* Re: The problem to start IoTDB
>
> Hi Tsung-Han,
>
> Thanks for your report.
>
> I can not reproduce your issue on my MacOS..  The similar report on [1]
> may be caused if your maven building process is interrupted.
>
> But after reading the source code of `start-client.sh`, I think your
> solution 2 is needed: Now, `start-client.sh` requires copying jars from the
> `iotdb` module rather than just from the `iotdb-cli` module. That does not
> make sense.
>
> We are very glad to see the coming PR from you.
>
> [1] https://www.mail-archive.com/dev@iotdb.apache.org/msg00913.html
>
> Best,
> ---
> Xiangdong Huang
> School of Software, Tsinghua University
>
> 黄向东
> 清华大学 软件学院
>
>
> Jack Tsai  于2019年5月23日周四 下午10:57写道：
>
> Hi everyone,
>
> I am the Chinese student from University of Liverpool who is going to be
> the internship in IoTDB team this summer.
>
> I found a problem when I start the IoTDB's client, and I think my problem
> is the same as the user in this mail:
> https://www.mail-archive.com/dev@iotdb.apache.org/msg00913.html
>
> Even if you have make some changes to the documentation on the website, it
> would still make users confused.

Re: [jira] [Created] (IOTDB-101) This is an example of SQL in user manual. Why use sum function and mean function to process Boolean data???

[李天安]

Hi，
Thanks for your report, it’s our carelessness when writing user doc. I 
have pull a pr to fix it. Pr link is 
:https://github.com/apache/incubator-iotdb/pull/182 
 

Best Regards,
—
Tianan Li
School of Software, Tsinghua University

> 在 2019年5月24日，下午5:31，zhaoxiuting (JIRA)  写道：
> 
> zhaoxiuting created IOTDB-101:
> -
> 
> Summary: This is an example of SQL in user manual. Why use sum 
> function and mean function to process Boolean data???
> Key: IOTDB-101
> URL: https://issues.apache.org/jira/browse/IOTDB-101
> Project: Apache IoTDB
>  Issue Type: Bug
>Reporter: zhaoxiuting
> Attachments: image-2019-05-24-17-28-23-691.png
> 
> Step1：The first example of SQL in user manual is SELECT SUM(status), 
> SUM(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 
> 24.
> 
> The second  example of SQL in user manual is SELECT MEAN(status), 
> MEAN(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature 
> < 24
> 
> Step2:
> 
> !image-2019-05-24-17-28-23-691.png!
> 
> Exception:It is suggested to modify the example SQL statement in the user 
> manual.
> 
>  
> 
> 
> 
> --
> This message was sent by Atlassian JIRA
> (v7.6.3#76005)

Re: [jira] [Created] (IOTDB-100) Feedback after executing SQL statement, error

[李天安]

Hi，
I have pulled a pr to fix  this problem. The link is 
https://github.com/apache/incubator-iotdb/pull/181 


Best Regards,
—
Tianan Li
School of Software, Tsinghua University

> 在 2019年5月24日，下午5:23，zhaoxiuting (JIRA)  写道：
> 
> zhaoxiuting created IOTDB-100:
> -
> 
> Summary: Feedback after executing SQL statement, error
> Key: IOTDB-100
> URL: https://issues.apache.org/jira/browse/IOTDB-100
> Project: Apache IoTDB
>  Issue Type: Bug
>Reporter: zhaoxiuting
> Attachments: image-2019-05-24-17-18-16-367.png
> 
> Step1：Execute SQL statement  on IoTDB.The SQL statement is SELECT 
> SUM(status), SUM(temperature) FROM root.ln.wf01.wt01 WHERE 
> root.ln.wf01.wt01.temperature < 24
> 
> Step2:Feedback after executing SQL statement, error
> 
> !image-2019-05-24-17-18-16-367.png!
> 
> 
> 
> --
> This message was sent by Atlassian JIRA
> (v7.6.3#76005)

Re: [jira] [Created] (IOTDB-100) Feedback after executing SQL statement, error

[李天安]

Hi，
Thanks for your report, I have identified the problem and started to solve it.

Best Regards,
—
Tianan Li
School of Software, Tsinghua University

> 在 2019年5月24日，下午5:23，zhaoxiuting (JIRA)  写道：
> 
> zhaoxiuting created IOTDB-100:
> -
> 
> Summary: Feedback after executing SQL statement, error
> Key: IOTDB-100
> URL: https://issues.apache.org/jira/browse/IOTDB-100
> Project: Apache IoTDB
>  Issue Type: Bug
>Reporter: zhaoxiuting
> Attachments: image-2019-05-24-17-18-16-367.png
> 
> Step1：Execute SQL statement  on IoTDB.The SQL statement is SELECT 
> SUM(status), SUM(temperature) FROM root.ln.wf01.wt01 WHERE 
> root.ln.wf01.wt01.temperature < 24
> 
> Step2:Feedback after executing SQL statement, error
> 
> !image-2019-05-24-17-18-16-367.png!
> 
> 
> 
> --
> This message was sent by Atlassian JIRA
> (v7.6.3#76005)

[jira] [Created] (IOTDB-101) This is an example of SQL in user manual. Why use sum function and mean function to process Boolean data???

[zhaoxiuting (JIRA)]

zhaoxiuting created IOTDB-101:
-

 Summary: This is an example of SQL in user manual. Why use sum 
function and mean function to process Boolean data???
 Key: IOTDB-101
 URL: https://issues.apache.org/jira/browse/IOTDB-101
 Project: Apache IoTDB
  Issue Type: Bug
Reporter: zhaoxiuting
 Attachments: image-2019-05-24-17-28-23-691.png

Step1：The first example of SQL in user manual is SELECT SUM(status), 
SUM(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 
24.

The second  example of SQL in user manual is SELECT MEAN(status), 
MEAN(temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 
24

Step2:

!image-2019-05-24-17-28-23-691.png!

Exception:It is suggested to modify the example SQL statement in the user 
manual.

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (IOTDB-97) Try compression in RPC

[Jialin Qiao (JIRA)]

Jialin Qiao created IOTDB-97:


 Summary: Try compression in RPC
 Key: IOTDB-97
 URL: https://issues.apache.org/jira/browse/IOTDB-97
 Project: Apache IoTDB
  Issue Type: Improvement
Reporter: Jialin Qiao


When executing a batch insertion in JDBC with many insert statements (e.g., 
>1000), the message to be transferred will be very large. The write throughput 
may be improved by compressing the message transferred between client and 
server.

Currently, thrift is used in RPC. The protocol we use is TBinaryProtocol which 
does not compact the data that transferred. There are two ways to improve:

(1) Use TCompactProtocol instead of TBinaryProtocol. There are two classes need 
to be modified: JDBCService and IoTDBConnection. This protocol will compress 
the data in each RPC, I'm not sure whether this protocol is better when the 
size of transferred data is small. 

(2) We can just compress the data in executeBatch when the batch_size reaches a 
threshold.  Add a compressed string that stores the SQLs in IoTDBStatement and 
use a flag to determine whether this field is used.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (IOTDB-96) The JDBC interface throws an exception when executing the SQL statement "list user"

[zhaoxiuting (JIRA)]

zhaoxiuting created IOTDB-96:


 Summary: The JDBC interface throws an exception when executing the 
SQL statement "list user"
 Key: IOTDB-96
 URL: https://issues.apache.org/jira/browse/IOTDB-96
 Project: Apache IoTDB
  Issue Type: Bug
 Environment: linux
Reporter: zhaoxiuting
 Attachments: image-2019-05-24-14-39-19-300.png

Step1：Execute IoTDB-User-Guide-SQL-Test on 192.168.13019 Jenkins.

Step2：Build click.

 Step3: See result.

 

!image-2019-05-24-14-39-19-300.png!




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)