Repository: incubator-hawq-docs Updated Branches: refs/heads/master 973791b22 -> 458ef8ea4
DOCS: clarify pxf writable external tables (closes #125) Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/458ef8ea Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/458ef8ea Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/458ef8ea Branch: refs/heads/master Commit: 458ef8ea40d50271eee4a70f6995d3600a4790d4 Parents: 973791b Author: Lisa Owen <[email protected]> Authored: Thu Jun 22 12:44:41 2017 -0700 Committer: David Yozie <[email protected]> Committed: Thu Jun 22 12:44:41 2017 -0700 ---------------------------------------------------------------------- markdown/pxf/HBasePXF.html.md.erb | 2 +- markdown/pxf/PXFExternalTableandAPIReference.html.md.erb | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/458ef8ea/markdown/pxf/HBasePXF.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/pxf/HBasePXF.html.md.erb b/markdown/pxf/HBasePXF.html.md.erb index 4341de3..853960f 100644 --- a/markdown/pxf/HBasePXF.html.md.erb +++ b/markdown/pxf/HBasePXF.html.md.erb @@ -41,7 +41,7 @@ Before trying to access HBase data with PXF, verify the following: To create an external HBase table, use the following syntax: ``` sql -CREATE [READABLE|WRITABLE] EXTERNAL TABLE table_name +CREATE READABLE EXTERNAL TABLE table_name ( column_name data_type [, ...] | LIKE other_table ) LOCATION ('pxf://host[:port]/hbase-table-name?Profile=HBase') FORMAT 'CUSTOM' (Formatter='pxfwritable_import'); http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/458ef8ea/markdown/pxf/PXFExternalTableandAPIReference.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/pxf/PXFExternalTableandAPIReference.html.md.erb b/markdown/pxf/PXFExternalTableandAPIReference.html.md.erb index 3681079..096d41d 100644 --- a/markdown/pxf/PXFExternalTableandAPIReference.html.md.erb +++ b/markdown/pxf/PXFExternalTableandAPIReference.html.md.erb @@ -47,6 +47,8 @@ FORMAT 'custom' (formatter='pxfwritable_import|pxfwritable_export'); &RESOLVER=<resolver_class>] | ?PROFILE=profile-name ``` +**Note**: Not every PXF profile supports writable external tables. Refer to [Writing Data to HDFS](HDFSWritablePXF.html) for a detailed discussion of the HDFS plug-in profiles that support this feature. + <caption><span class="tablecap">Table 1. Parameter values and description</span></caption> <a id="creatinganexternaltable__table_pfy_htz_4p"></a>
