danny0405 commented on a change in pull request #1444: [CALCITE-3329] Implement
osquery for OS adapter
URL: https://github.com/apache/calcite/pull/1444#discussion_r323029167
##########
File path: site/_docs/os_adapter.md
##########
@@ -258,6 +258,209 @@ $ ./sqlsh select distinct jps.\`pid\`, jps.\`info\` from
jps
{% endhighlight %}
+## Example: system_info
+
+provides a display of system info In `sqlsh`:
+
+{% highlight bash %}
+$ ./sqlsh -o mysql select
user_name,local_hostname,ip,total_memory,free_memory,cpu_cores,cpu_mhz,os_name,os_arch,os_version
from system_info
++-----------+----------------+-------------+--------------+-------------+-----------+---------+----------+---------+------------+
+| user_name | local_hostname | ip | total_memory | free_memory |
cpu_cores | cpu_mhz | os_name | os_arch | os_version |
++-----------+----------------+-------------+--------------+-------------+-----------+---------+----------+---------+------------+
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
+| forwardxu | FORWARDXU-MB0 | 10.68.84.42 | 189267968 | 175867248 |
12 | 2200 | Mac OS X | x86_64 | 10.14.5 |
++-----------+----------------+-------------+--------------+-------------+-----------+---------+----------+---------+------------+
+(12 rows)
+
+The complete fields are as follows:
+user_name,
+computer_name,
+user_domain,
+ip,
+local_hostname,
+total_memory,
+free_memory,
+available_processors,
+cpu_cores,
+cpu_mhz,
+cpu_vendor,
+cpu_cache_size,
+os_name,
+os_arch,
+os_version,
+file_separator,
+path_separator,
+line_separator,
+user_home,
+user_dir
+
+{% endhighlight %}
+
+## Example: java_info
+
+provides a display of java info In `sqlsh`:
+
Review comment:
Start line with uppercase character.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
