Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [brian@biosphere ~]$ mclient -u monetdb -d myschema
- password:
- Welcome TO mclient, the MonetDB/SQL interactive terminal (Oct2012-SP3)
- DATABASE: MonetDB v11.13.9 (Oct2012-SP3), 'mapi:monetdb://biosphere:50000/myschema'
- TYPE \q TO quit, \? FOR a list OF available commands
- auto commit mode: ON
- sql>\q
- [brian@biosphere ~]$ mclient -u monetdb -d myschema
- password:
- Welcome TO mclient, the MonetDB/SQL interactive terminal (Oct2012-SP3)
- DATABASE: MonetDB v11.13.9 (Oct2012-SP3), 'mapi:monetdb://biosphere:50000/myschema'
- TYPE \q TO quit, \? FOR a list OF available commands
- auto commit mode: ON
- sql>SELECT a.ip_dst AS ip_dst, b.tcp_dport AS tcp_dport, COUNT(*) AS num FROM "myschema".tablea a LEFT JOIN "myschema".tableb b ON (a.guid = b.guid) WHERE b.tcp_dport IS NOT NULL GROUP BY a.ip_dst, b.tcp_dport ORDER BY num DESC LIMIT 20;
- +-----------------+-----------+---------+
- | ip_dst | tcp_dport | num |
- +=================+===========+=========+
- DATA Ommited
- +-----------------+-----------+---------+
- 20 tuples (1m 19s)
- sql>SELECT a.ip_dst AS ip_dst, b.udp_dport AS udp_dport, COUNT(*) AS num FROM "myschema".tablea a LEFT JOIN "myschema".tablec b ON (a.guid = b.guid) WHERE b.udp_dport IS NOT NULL GROUP BY a.ip_dst, b.udp_dport ORDER BY num DESC LIMIT 20;
- Connection TERMINATED
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement