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

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

diff --git a/demo/GDATEXAMPLE/example.gsql b/demo/GDATEXAMPLE/example.gsql
new file mode 100644 (file)
index 0000000..4ebc9f0
--- /dev/null
+++ b/demo/GDATEXAMPLE/example.gsql
@@ -0,0 +1,11 @@
+DEFINE {
+query_name 'example';
+visibility 'external';
+}
+select systemTime,uintInPosition1,ullongInPosition2,ipInPosition3,
+       ipv6InPosition4,stringInPosition5,boolInPosition6,intInPosition7,
+       llongInPosition8,floatInPosition9,count(*) as cnt
+from [gdat].GDAT_EXAMPLE
+group by systemTime,uintInPosition1,ullongInPosition2,ipInPosition3,
+       ipv6InPosition4,stringInPosition5,boolInPosition6,intInPosition7,
+       llongInPosition8,floatInPosition9