http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/clientaccess/g-supported-client-applications.html
----------------------------------------------------------------------
diff --git 
a/docs/userguide/2.1.0.0-incubating/clientaccess/g-supported-client-applications.html
 
b/docs/userguide/2.1.0.0-incubating/clientaccess/g-supported-client-applications.html
index a1dd89d..d3a5910 100644
--- 
a/docs/userguide/2.1.0.0-incubating/clientaccess/g-supported-client-applications.html
+++ 
b/docs/userguide/2.1.0.0-incubating/clientaccess/g-supported-client-applications.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/clientaccess/g-troubleshooting-connection-problems.html
----------------------------------------------------------------------
diff --git 
a/docs/userguide/2.1.0.0-incubating/clientaccess/g-troubleshooting-connection-problems.html
 
b/docs/userguide/2.1.0.0-incubating/clientaccess/g-troubleshooting-connection-problems.html
index 9c83a64..df7818e 100644
--- 
a/docs/userguide/2.1.0.0-incubating/clientaccess/g-troubleshooting-connection-problems.html
+++ 
b/docs/userguide/2.1.0.0-incubating/clientaccess/g-troubleshooting-connection-problems.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/clientaccess/index.html
----------------------------------------------------------------------
diff --git a/docs/userguide/2.1.0.0-incubating/clientaccess/index.html 
b/docs/userguide/2.1.0.0-incubating/clientaccess/index.html
index cb0065d..7f5c58a 100644
--- a/docs/userguide/2.1.0.0-incubating/clientaccess/index.html
+++ b/docs/userguide/2.1.0.0-incubating/clientaccess/index.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/clientaccess/kerberos.html
----------------------------------------------------------------------
diff --git a/docs/userguide/2.1.0.0-incubating/clientaccess/kerberos.html 
b/docs/userguide/2.1.0.0-incubating/clientaccess/kerberos.html
index 5d42369..bcdcc29 100644
--- a/docs/userguide/2.1.0.0-incubating/clientaccess/kerberos.html
+++ b/docs/userguide/2.1.0.0-incubating/clientaccess/kerberos.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/clientaccess/ldap.html
----------------------------------------------------------------------
diff --git a/docs/userguide/2.1.0.0-incubating/clientaccess/ldap.html 
b/docs/userguide/2.1.0.0-incubating/clientaccess/ldap.html
index 7e72e7d..8d2c568 100644
--- a/docs/userguide/2.1.0.0-incubating/clientaccess/ldap.html
+++ b/docs/userguide/2.1.0.0-incubating/clientaccess/ldap.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/clientaccess/roles_privs.html
----------------------------------------------------------------------
diff --git a/docs/userguide/2.1.0.0-incubating/clientaccess/roles_privs.html 
b/docs/userguide/2.1.0.0-incubating/clientaccess/roles_privs.html
index a10680a..2868216 100644
--- a/docs/userguide/2.1.0.0-incubating/clientaccess/roles_privs.html
+++ b/docs/userguide/2.1.0.0-incubating/clientaccess/roles_privs.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/BasicDataOperations.html
----------------------------------------------------------------------
diff --git 
a/docs/userguide/2.1.0.0-incubating/datamgmt/BasicDataOperations.html 
b/docs/userguide/2.1.0.0-incubating/datamgmt/BasicDataOperations.html
index 12e846b..2218224 100644
--- a/docs/userguide/2.1.0.0-incubating/datamgmt/BasicDataOperations.html
+++ b/docs/userguide/2.1.0.0-incubating/datamgmt/BasicDataOperations.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/ConcurrencyControl.html
----------------------------------------------------------------------
diff --git a/docs/userguide/2.1.0.0-incubating/datamgmt/ConcurrencyControl.html 
b/docs/userguide/2.1.0.0-incubating/datamgmt/ConcurrencyControl.html
index c35484e..f577134 100644
--- a/docs/userguide/2.1.0.0-incubating/datamgmt/ConcurrencyControl.html
+++ b/docs/userguide/2.1.0.0-incubating/datamgmt/ConcurrencyControl.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/HAWQInputFormatforMapReduce.html
----------------------------------------------------------------------
diff --git 
a/docs/userguide/2.1.0.0-incubating/datamgmt/HAWQInputFormatforMapReduce.html 
b/docs/userguide/2.1.0.0-incubating/datamgmt/HAWQInputFormatforMapReduce.html
index e849949..7d5fb28 100644
--- 
a/docs/userguide/2.1.0.0-incubating/datamgmt/HAWQInputFormatforMapReduce.html
+++ 
b/docs/userguide/2.1.0.0-incubating/datamgmt/HAWQInputFormatforMapReduce.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/Transactions.html
----------------------------------------------------------------------
diff --git a/docs/userguide/2.1.0.0-incubating/datamgmt/Transactions.html 
b/docs/userguide/2.1.0.0-incubating/datamgmt/Transactions.html
index 756c58c..3e1c76b 100644
--- a/docs/userguide/2.1.0.0-incubating/datamgmt/Transactions.html
+++ b/docs/userguide/2.1.0.0-incubating/datamgmt/Transactions.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/about_statistics.html
----------------------------------------------------------------------
diff --git a/docs/userguide/2.1.0.0-incubating/datamgmt/about_statistics.html 
b/docs/userguide/2.1.0.0-incubating/datamgmt/about_statistics.html
index 2a26feb..76fc488 100644
--- a/docs/userguide/2.1.0.0-incubating/datamgmt/about_statistics.html
+++ b/docs/userguide/2.1.0.0-incubating/datamgmt/about_statistics.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/dml.html
----------------------------------------------------------------------
diff --git a/docs/userguide/2.1.0.0-incubating/datamgmt/dml.html 
b/docs/userguide/2.1.0.0-incubating/datamgmt/dml.html
index ea66c04..14f2402 100644
--- a/docs/userguide/2.1.0.0-incubating/datamgmt/dml.html
+++ b/docs/userguide/2.1.0.0-incubating/datamgmt/dml.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/load/client-loadtools.html
----------------------------------------------------------------------
diff --git 
a/docs/userguide/2.1.0.0-incubating/datamgmt/load/client-loadtools.html 
b/docs/userguide/2.1.0.0-incubating/datamgmt/load/client-loadtools.html
index cce2fc2..1f3c369 100644
--- a/docs/userguide/2.1.0.0-incubating/datamgmt/load/client-loadtools.html
+++ b/docs/userguide/2.1.0.0-incubating/datamgmt/load/client-loadtools.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/load/creating-external-tables-examples.html
----------------------------------------------------------------------
diff --git 
a/docs/userguide/2.1.0.0-incubating/datamgmt/load/creating-external-tables-examples.html
 
b/docs/userguide/2.1.0.0-incubating/datamgmt/load/creating-external-tables-examples.html
index 60d3676..edc1238 100644
--- 
a/docs/userguide/2.1.0.0-incubating/datamgmt/load/creating-external-tables-examples.html
+++ 
b/docs/userguide/2.1.0.0-incubating/datamgmt/load/creating-external-tables-examples.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>
@@ -981,7 +989,7 @@
 <p>Creates a readable external table, <code>ext_expenses</code>, using the 
<code>gpfdist</code> protocol. The files are formatted with a pipe (|) as the 
column delimiter.</p>
 <pre class="highlight sql"><code><span class="o">=#</span> <span 
class="k">CREATE</span> <span class="k">EXTERNAL</span> <span 
class="k">TABLE</span> <span class="n">ext_expenses</span>
         <span class="p">(</span> <span class="n">name</span> <span 
class="n">text</span><span class="p">,</span> <span class="n">date</span> <span 
class="n">date</span><span class="p">,</span> <span class="n">amount</span> 
<span class="n">float4</span><span class="p">,</span> <span 
class="n">category</span> <span class="n">text</span><span class="p">,</span> 
<span class="n">desc1</span> <span class="n">text</span> <span 
class="p">)</span>
-    <span class="k">LOCATION</span> <span class="p">(</span><span 
class="s1">'gpfdist://etlhost-1:8081/*'</span><span class="p">,</span> <span 
class="s1">'gpfdist://etlhost-1:8082/*'</span><span class="p">)</span>
+    <span class="k">LOCATION</span> <span class="p">(</span><span 
class="s1">'gpfdist://etlhost-1:8081/*'</span><span class="p">)</span>
     <span class="n">FORMAT</span> <span class="s1">'TEXT'</span> <span 
class="p">(</span><span class="k">DELIMITER</span> <span 
class="s1">'|'</span><span class="p">);</span>
 </code></pre>
 

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-about-gpfdist-setup-and-performance.html
----------------------------------------------------------------------
diff --git 
a/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-about-gpfdist-setup-and-performance.html
 
b/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-about-gpfdist-setup-and-performance.html
index 6a20322..17c8f6b 100644
--- 
a/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-about-gpfdist-setup-and-performance.html
+++ 
b/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-about-gpfdist-setup-and-performance.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-character-encoding.html
----------------------------------------------------------------------
diff --git 
a/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-character-encoding.html 
b/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-character-encoding.html
index d22dadb..1f88e91 100644
--- a/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-character-encoding.html
+++ b/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-character-encoding.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

http://git-wip-us.apache.org/repos/asf/incubator-hawq-site/blob/cce3ea48/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-command-based-web-external-tables.html
----------------------------------------------------------------------
diff --git 
a/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-command-based-web-external-tables.html
 
b/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-command-based-web-external-tables.html
index 28e580c..16ceca8 100644
--- 
a/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-command-based-web-external-tables.html
+++ 
b/docs/userguide/2.1.0.0-incubating/datamgmt/load/g-command-based-web-external-tables.html
@@ -129,11 +129,13 @@
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/setuphawqopenv.html">Introducing 
the HAWQ Operating Environment</a>
           </li>
-          <li>
+          <li class="has_submenu">
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-admin.html">Managing HAWQ 
Using Ambari</a>
-          </li>
-          <li>
-            <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+           <ul>
+            <li>
+              <a 
href="/docs/userguide/2.1.0.0-incubating/admin/ambari-rest-api.html">Using the 
Ambari REST API</a>
+            </li>
+           </ul>
           </li>
           <li>
             <a 
href="/docs/userguide/2.1.0.0-incubating/admin/startstop.html">Starting and 
Stopping HAWQ</a>
@@ -413,6 +415,7 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HivePXF.html">Accessing Hive 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HBasePXF.html">Accessing HBase 
Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/JsonPXF.html">Accessing JSON 
Data</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/HDFSWritablePXF.html">Writing Data 
to HDFS</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/ReadWritePXF.html">Using Profiles 
to Read and Write Data</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/PXFExternalTableandAPIReference.html">PXF
 External Tables and API</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/pxf/TroubleshootingPXF.html">Troubleshooting
 PXF</a></li>
@@ -740,6 +743,7 @@
             <ul>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ABORT.html">ABORT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-AGGREGATE.html">ALTER
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-CONVERSION.html">ALTER
 CONVERSION</a></li>  
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-DATABASE.html">ALTER
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-FUNCTION.html">ALTER
 FUNCTION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/ALTER-OPERATOR.html">ALTER
 OPERATOR</a></li>
@@ -757,6 +761,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COMMIT.html">COMMIT</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/COPY.html">COPY</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-AGGREGATE.html">CREATE
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CAST.html">CREATE 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-CONVERSION.html">CREATE
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-DATABASE.html">CREATE
 DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-EXTERNAL-TABLE.html">CREATE
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/CREATE-FUNCTION.html">CREATE
 FUNCTION</a></li>
@@ -777,6 +783,8 @@
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DEALLOCATE.html">DEALLOCATE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DECLARE.html">DECLARE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-AGGREGATE.html">DROP
 AGGREGATE</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CAST.html">DROP 
CAST</a></li>
+              <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-CONVERSION.html">DROP
 CONVERSION</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-DATABASE.html">DROP 
DATABASE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-EXTERNAL-TABLE.html">DROP
 EXTERNAL TABLE</a></li>
               <li><a 
href="/docs/userguide/2.1.0.0-incubating/reference/sql/DROP-FILESPACE.html">DROP
 FILESPACE</a></li>

Reply via email to