Updates to examples queries. Improve real-timeness of lfta aggregation

[com/gs-lite.git] / demo / CSVEXAMPLE / example.gsql

diff --git a/demo/CSVEXAMPLE/example.gsql b/demo/CSVEXAMPLE/example.gsql
new file mode 100644 (file)
index 0000000..9a019cb
--- /dev/null
+++ b/demo/CSVEXAMPLE/example.gsql
@@ -0,0 +1,10 @@
+DEFINE {
+query_name 'example';
+}
+select systemTime,uintInPosition1,ullongInPosition2,ipInPosition3,
+       ipv6InPosition4,stringInPosition5,boolInPosition6,intInPosition7,
+       llongInPosition8,floatInPosition9,count(*) as Cnt
+from [csv].CSV_EXAMPLE
+group by systemTime,uintInPosition1,ullongInPosition2,ipInPosition3,
+       ipv6InPosition4,stringInPosition5,boolInPosition6,intInPosition7,
+       llongInPosition8,floatInPosition9