René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Empty query response","articleBody":"**Describe this problem**\r\n\r\n\u003c!---\r\nWhat this problem is and what happened.\r\n-->\r\n\r\n**Steps to reproduce**\r\n\r\n1. Create table\r\n```\r\ncurl --location --request POST 'http://127.0.0.1:5440/sql' --data-raw '\r\nCREATE TABLE `demo` (\r\n    `name` string TAG,\r\n    `value` double NOT NULL,\r\n    `t` timestamp NOT NULL,\r\n    `t2` timestamp NOT NULL,\r\n    timestamp KEY (t))\r\nENGINE=Analytic\r\n  with\r\n(enable_ttl=\"false\")\r\n```\r\n2. Insert a row\r\n```\r\ncurl --location --request POST 'http://127.0.0.1:5440/sql' --data-raw '\r\nINSERT INTO demo (t, t2, name, value)\r\n    VALUES (1651737067000, 1651737067009, \"ceresdb\", 100)\r\n'\r\n```\r\n3. Query by http interface\r\n```\r\ncurl --location --request POST 'http://127.0.0.1:5440/sql' --data-raw '\r\nSELECT t, avg(value) FROM `demo` group by t\r\n'\r\n```\r\n\r\nresponse: \r\n```\r\n{\"rows\":[{\"t\":1651737067000,\"AVG(demo.value)\":100.0}]}\r\n```\r\n4. Query by Java SDK\r\n```\r\n        CeresDBClient client = getClient();\r\n        String query = \"SELECT t, avg(value) FROM `demo` group by t\";\r\n        SqlQueryRequest request = new SqlQueryRequest(query);\r\n        CompletableFuture\u003cResult\u003cSqlQueryOk, Err>> future = client.sqlQuery(request);\r\n        Result\u003cSqlQueryOk, Err> result = future.get();\r\n        System.out.println(result);\r\n``` \r\nThe response's rowCount is 0.\r\n\r\n**Expected behavior**\r\n\r\n\r\n**Additional Information**\r\n","author":{"url":"https://github.com/zouxiang1993","@type":"Person","name":"zouxiang1993"},"datePublished":"2023-03-30T03:42:16Z","url":"https://github.com/apache/horaedb-client-java/issues/58"}