[
https://issues.apache.org/jira/browse/HAWQ-1491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16065667#comment-16065667
]
ASF GitHub Bot commented on HAWQ-1491:
--------------------------------------
Github user sansanichfb commented on a diff in the pull request:
https://github.com/apache/incubator-hawq-docs/pull/126#discussion_r124423164
--- Diff: markdown/pxf/HivePXF.html.md.erb ---
@@ -565,6 +577,44 @@ In the following example, you will create a Hive table
stored in ORC format and
Time: 425.416 ms
```
+### <a id="using-hiveorc-profile"></a>Example: Using the HiveVectorizedORC
Profile
+
+In the following example, you will use the `HiveVectorizedORC` profile to
query the `sales_info_ORC` Hive table you created in the previous example.
+
+**Note**: The `HiveVectorizedORC` profile does not support the timestamp
data type and complex types.
+
+1. Start the `psql` subsystem:
+
+ ``` shell
+ $ psql -d postgres
+ ```
+
+2. Use the PXF `HiveVectorizedORC` profile to create a queryable HAWQ
external table from the Hive table named `sales_info_ORC` that you created in
Step 1 of the previous example. The `FORMAT` clause must specify `'CUSTOM'`.
The `HiveVectorizedORC` `CUSTOM` format supports only the built-in
`'pxfwritable_import'` `formatter`.
--- End diff --
queryable - maybe readable?
> docs - add usage info for HiveVectorizedORC profile
> ---------------------------------------------------
>
> Key: HAWQ-1491
> URL: https://issues.apache.org/jira/browse/HAWQ-1491
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: Documentation
> Reporter: Lisa Owen
> Assignee: David Yozie
>
> add usage info and an example for the new HiveVectorizedORC profile to the
> Hive plug-in page.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
