Is there any online url for VSQL tutorial ?
Hi,
I am looking for the detail information related to VSQL. I wonder if there is any specific url for VSQL tutorial
0
Hi,
I am looking for the detail information related to VSQL. I wonder if there is any specific url for VSQL tutorial
Comments
Hi,
Please find the URL below. http://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/ProgrammersGuide/vsql/UsingVsql.htm%3FTocPath%3DProgrammer's%20Guide%7CUsing%20vsql%7C_____0
It explains all the options regarding vsql and its usage
-Regards,
Sruthi
Hello Shruti,
Thanks for the response. I am looking some more vsql statements further more which i did not find in the documents. For example like I want to check the following information from VSQL
CPU/Memory/Disk I/O(Last Hour)
'General Pool' Activity
Database Nodes Health
Query Processing Activity
Database Nodes Health
I/O Wait Notices
Workload Analyzer
Projections
Hi,
The following links provide you with the required information.
1. V_CATALOG schema contains system tables provide information (metadata) about tables, constraints, users, projections, and so on.
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/CATALOG/V_CATALOGSchema.htm%3FTocPath%3DSQL%2520Reference%2520Manual%7CHP%2520Vertica%2520System%2520Tables%7CV_CATALOG%2520Schema%7C_____0
2. V_MONITOR schema contains system tables that provide information about the health of the HP Vertica database.
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/V_MONITORSchema.htm%3FTocPath%3DSQL%2520Reference%2520Manual%7CHP%2520Vertica%2520System%2520Tables%7CV_MONITOR%2520Schema%7C_____0
-Regards,
Sruthi