[jira] [Closed] (IOTDB-498) Support date format "2020-02-10"

2020-03-03 Thread Jialin Qiao (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jialin Qiao closed IOTDB-498. - Fix Version/s: 0.10.0-SNAPSHOT Resolution: Fixed > Support date format "2020-02-10" >

Re: Prepared Statements/ Commit

2020-03-03 Thread Julian Feinauer
Hey Willem, this is a good idea... probably it even makes sense to use Apache Avatica for a full featured JDBC Driver? Julian Am 03.03.20, 15:51 schrieb "Willem Jiang" : It's not difficult to build a component of IoTDB for Camel with Session API。 But it's could be great if the IoTDB

Re: Prepared Statements/ Commit

2020-03-03 Thread Julian Feinauer
Yes, why not? This should not be too hard to do... Camels API is quite friendly. What do you think? Julian Am 03.03.20, 15:25 schrieb "Robinet, Etienne" <43...@etu.he2b.be>: Hi Julian, you're thinking about creating a Camel component? Le mar. 3 mars 2020 à 15:24, Julian

Re: Prepared Statements/ Commit

2020-03-03 Thread Robinet, Etienne
Hi, Yes I am using Karaf, I am currently testing and discussing about creating a temporary Camel component, but I will also try this approach. Le mar. 3 mars 2020 à 16:01, Willem Jiang a écrit : > With Bean API[1], you can write a customer Bean to use the Session API > to send the data into

Re: Prepared Statements/ Commit

2020-03-03 Thread Willem Jiang
With Bean API[1], you can write a customer Bean to use the Session API to send the data into IoTDB. Just a quick question, are you using Karaf (OSGi) this time? If so, you may need to provide a wrapped OSGi IoTDB client jar for it.

[jira] [Created] (IOTDB-539) reduce GroupByWithoutValueFilter unnecessary BatchData reads

2020-03-03 Thread DaweiLiu (Jira)
DaweiLiu created IOTDB-539: -- Summary: reduce GroupByWithoutValueFilter unnecessary BatchData reads Key: IOTDB-539 URL: https://issues.apache.org/jira/browse/IOTDB-539 Project: Apache IoTDB Issue

[jira] [Commented] (IOTDB-535) Do we need a more accurate data type in the ResultSet for aggregation functions

2020-03-03 Thread Yuxin Zhang (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17050279#comment-17050279 ] Yuxin Zhang commented on IOTDB-535: --- Hi, we have precise data types for aggregations. For example, the

Re: Prepared Statements/ Commit

2020-03-03 Thread Willem Jiang
It's not difficult to build a component of IoTDB for Camel with Session API。 But it's could be great if the IoTDB provide standard support the JDBC, as we may hit another issue of JDBC support. Is it possible that IoTDB implements the getParameterMetaData method this time? Willem Jiang Twitter:

Re: Prepared Statements/ Commit

2020-03-03 Thread Xiangdong Huang
Hi, @Etienne many thanks for your link, I will read it later. @Julian can you give us a link to help me understand that? Hi @Willem Jiang (the IoTDB mentor and the Camel committer), how do you think about that? Best. --- Xiangdong Huang School of Software,

Re: Prepared Statements/ Commit

2020-03-03 Thread Robinet, Etienne
Hi Julian, you're thinking about creating a Camel component? Le mar. 3 mars 2020 à 15:24, Julian Feinauer a écrit : > Hi, > > another alternative would be to add a "native" IoTDB Integration like .e.g > we did in PLC4X. Its not that hard and should be easy for the IoTDB > community. > > What

Re: Prepared Statements/ Commit

2020-03-03 Thread Julian Feinauer
Hi, another alternative would be to add a "native" IoTDB Integration like .e.g we did in PLC4X. Its not that hard and should be easy for the IoTDB community. What about that? Julian Am 03.03.20, 14:35 schrieb "Robinet, Etienne" <43...@etu.he2b.be>: Hi, sadly I am pretty new at using

[jira] [Commented] (IOTDB-498) Support date format "2020-02-10"

2020-03-03 Thread Jialin Qiao (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17050240#comment-17050240 ] Jialin Qiao commented on IOTDB-498: --- Yes > Support date format "2020-02-10" >

[jira] [Created] (IOTDB-538) Add a simple Connection pool to simplify usage for Session API

2020-03-03 Thread Xiangdong Huang (Jira)
Xiangdong Huang created IOTDB-538: - Summary: Add a simple Connection pool to simplify usage for Session API Key: IOTDB-538 URL: https://issues.apache.org/jira/browse/IOTDB-538 Project: Apache IoTDB

[jira] [Commented] (IOTDB-498) Support date format "2020-02-10"

2020-03-03 Thread Haonan Hou (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17050213#comment-17050213 ] Haonan Hou commented on IOTDB-498: -- Hi, can you please provide more details about what kinds of 

Re: Prepared Statements/ Commit

2020-03-03 Thread Robinet, Etienne
Hi, sadly I am pretty new at using camel and never worked with NoSQL DB but I found this: https://rterp.wordpress.com/2014/07/25/writing-to-a-nosql-db-using-camel/ Also, here is a blueprint I used with Oracle DB: http://www.osgi.org/xmlns/blueprint/v1.0.0;

[jira] [Commented] (IOTDB-537) An exception when using 'disable align'

2020-03-03 Thread Haonan Hou (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17050182#comment-17050182 ] Haonan Hou commented on IOTDB-537: -- This issue will be fixed with

Re: Prepared Statements/ Commit

2020-03-03 Thread Robinet, Etienne
Hi, Okay I will look into this. But my goal was to use existing JDBC/SQL component of Camel to communicate with IoTDB. Regards, Etienne Le mar. 3 mars 2020 à 14:04, Jialin Qiao a écrit : > Hi, > > If you only need a java api, the Session API is enough and better than > JDBC. > > There is an

Re: Prepared Statements/ Commit

2020-03-03 Thread Xiangdong Huang
Hi Etienne, Can you share an example for integration Camel with some other DB (NoSQL is better)? It will be helpful to let us evaluate how to integrate with IoTDB. Best, -- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Jialin Qiao

Re: Prepared Statements/ Commit

2020-03-03 Thread Jialin Qiao
Hi, If you only need a java api, the Session API is enough and better than JDBC. There is an example about Session API: https://github.com/apache/incubator-iotdb/blob/master/example/session/src/main/java/org/apache/iotdb/SessionExample.java I'm not familiar with Camel, but when integrating

Re: Prepared Statements/ Commit

2020-03-03 Thread Robinet, Etienne
Hi, Can I use this session API in combination with camel? Le mar. 3 mars 2020 à 13:54, Jialin Qiao a écrit : > Hi, > > PreparedStatement is not supported now. Instead, you could use Session > API, which also avoids the sql parser. > > Thanks, > -- > Jialin Qiao > School of Software, Tsinghua

Re: Prepared Statements/ Commit

2020-03-03 Thread Jialin Qiao
Hi, PreparedStatement is not supported now. Instead, you could use Session API, which also avoids the sql parser. Thanks, -- Jialin Qiao School of Software, Tsinghua University 乔嘉林 清华大学 软件学院 > -原始邮件- > 发件人: "Etienne Robinet" <43...@etu.he2b.be> > 发送时间: 2020-03-03 20:35:56 (星期二) > 收件人:

Prepared Statements/ Commit

2020-03-03 Thread Etienne Robinet
Hi all, could it be that IoTDB doesn't support prepared statements? When I try to use the SQL component of Camel, this is the error I get:https://i.imgur.com/HOJgh0H.png when I use JDBC component I get an error message "Not support Commit". I am confused now on how to use camel with IoTDB.

[jira] [Closed] (IOTDB-430) using star to get records count is poor efficiency than using integer

2020-03-03 Thread Jialin Qiao (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jialin Qiao closed IOTDB-430. - Resolution: Not A Problem > using star to get records count is poor efficiency than using integer >

[jira] [Commented] (IOTDB-430) using star to get records count is poor efficiency than using integer

2020-03-03 Thread Jialin Qiao (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17050003#comment-17050003 ] Jialin Qiao commented on IOTDB-430: --- +1 for not doing this issue. As discussed before, this issue will

Re: Karaf features

2020-03-03 Thread Xiangdong Huang
Sorry, my fault. I thought "kafka".. acutally it is Karaf.. please ignore me... --- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Robinet, Etienne <43...@etu.he2b.be> 于2020年3月3日周二 下午4:30写道: > Hi, > I am using Camel routes inside a Karaf

[jira] [Commented] (IOTDB-430) using star to get records count is poor efficiency than using integer

2020-03-03 Thread Xiangdong Huang (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17050001#comment-17050001 ] Xiangdong Huang commented on IOTDB-430: --- +1 for not implementing count(1) > using star to get

Re: Karaf features

2020-03-03 Thread Robinet, Etienne
Hi, I am using Camel routes inside a Karaf Container so I don't directly understand the link to this? Etienne Le mar. 3 mars 2020 à 09:28, Xiangdong Huang a écrit : > Hi Etienne, > > A PR for integration Flink is under review [1], which may be similar to the > integration with Kafka. > > [1]

Re: Karaf features

2020-03-03 Thread Xiangdong Huang
Hi Etienne, A PR for integration Flink is under review [1], which may be similar to the integration with Kafka. [1] https://github.com/apache/incubator-iotdb/pull/817 Best, --- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Robinet,

[jira] [Commented] (IOTDB-430) using star to get records count is poor efficiency than using integer

2020-03-03 Thread Julian Feinauer (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17049995#comment-17049995 ] Julian Feinauer commented on IOTDB-430: --- Agree with [~haonan] here. In an RDBMS the query is

[jira] [Commented] (IOTDB-430) using star to get records count is poor efficiency than using integer

2020-03-03 Thread Haonan Hou (Jira)
[ https://issues.apache.org/jira/browse/IOTDB-430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17049994#comment-17049994 ] Haonan Hou commented on IOTDB-430: -- Hi, I tried to use count(1) in 0.10.0, but I don't think there are

[jira] [Created] (IOTDB-536) Process about nonExistMeasurement and ConstantMeasurement in AlignByDevice is complex and not intuitive

2020-03-03 Thread XiangweiWei (Jira)
XiangweiWei created IOTDB-536: - Summary: Process about nonExistMeasurement and ConstantMeasurement in AlignByDevice is complex and not intuitive Key: IOTDB-536 URL: https://issues.apache.org/jira/browse/IOTDB-536