vvysotskyi commented on a change in pull request #2030: Update docs for
Metastore to point that all format plugins are supported
URL: https://github.com/apache/drill/pull/2030#discussion_r394890958
##########
File path: _docs/connect-a-data-source/035-plugin-configuration-basics.md
##########
@@ -147,6 +149,45 @@ fieldDelimiter => ',', extractHeader => true))``
For more information about format plugin configuration see ["Text Files: CSV,
TSV, PSV"]({{site.baseurl}}{{site.baseurl}}/docs/text-files-csv-tsv-psv/).
+## Specifying the Schema as Table Function Parameter
+
+Starting from Drill 1.17, table schema may be indicated in the query using
table function.
+
+It is useful when the user does not want to persist schema in table root
location or when reading from file, not folder.
+Schema parameter can be used as an individual unit or together with format
plugin table properties.
+
+Schema can be provided in the `SCHEMA` property inline or using the file.
+
+The syntax for inline schema is similar to the [CREATE OR REPLACE
SCHEMA]({{site.baseurl}}/docs/create-or-replace-schema/#syntax):
+
+```
+SELECT a, b FROM TABLE (table_name(
+SCHEMA => 'inline=(column_name data_type [nullability] [format] [default]
[properties {prop='val', ...})]'))
+```
+
+Example of usage:
+
+```
+select * from table(dfs.tmp.`text_table`(
+schema => 'inline=(col1 date properties {`drill.format` = `yyyy-MM-dd`})
+properties {`drill.strict` = `false`}'))
+```
+
+The syntax for indicating schema using the path:
Review comment:
Replaced
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
