[ https://issues.apache.org/jira/browse/DRILL-6667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Rogers updated DRILL-6667: ------------------------------- Description: The Drill documentation provides the "Sample Datasets" section, which is very handy. However, this section does not discuss the two datasets provided with Drill itself. * Julian Hyde's [FoodMart data set|https://github.com/julianhyde/foodmart-data-hsqldb], available on the class path. * TPC-H data set, available on the class path in {{tpch}} The "FoodMart" data set is available directly under {{cp}}. In fact, the Drill sample query (see below) references a FoodMart table. To see the list of tables (at development time), find the {{foodmark-data-json-0.4.jar}} file in the Maven dependencies for {{drill-java-exec}}. The table names here are simplified relative to those in the ER diagram in the above link. Perhaps include a simple table with names, and the mapping to the original names, and a link to (or just embed the link) to the FoodMart ER image. The data is available in JSON format. TPCH data is available in {{`cp`.`tpch/*.parquet`}}, in Parquet format. The schema is described in the [TPC-H specification|http://www.tpc.org/tpc_documents_current_versions/current_specifications.asp]. These are very handy, but hard to find: I find I must keep searching the source code to remember file names and directory paths. End uses won't have this luxury. Suggestion: Describe the files available in the class path data source. Along these same lines, in "Connect a Data Source", there is no mention of the class path data source. Yet, we reference that data source in the Web Console where we suggest a sample query to run: {code} Sample SQL query: SELECT * FROM cp.`employee.json` LIMIT 20 {code} The above query refers to the FoodMart data set. was: The Drill documentation provides the "Sample Datasets" section, which is very handy. However, this section does not discuss the two datasets provided with Drill itself. * Julian Hyde's [FoodMart data set|https://github.com/julianhyde/foodmart-data-hsqldb], available on the class path. * TPC-H data set, available on the class path in {{tpch}} The "FoodMart" data set is available directly under {{cp}}. In fact, the Drill sample query (see below) references a FoodMart table. To see the list of tables (at development time), find the {{foodmark-data-json-0.4.jar}} file in the Maven dependencies for {{drill-java-exec}}. The table names here are simplified relative to those in the ER diagram in the above link. Perhaps include a simple table with names, and the mapping to the original names, and a link to (or just embed the link) to the FoodMart ER image. The data is available in JSON format. TPCH data is available in {{`cp`.`tpch/*.parquet`}}, in Parquet format. The schema is described in the [TPC-H specification|http://www.tpc.org/tpc_documents_current_versions/current_specifications.asp]. Suggestion: Describe the files available in the class path data source. Along these same lines, in "Connect a Data Source", there is no mention of the class path data source. Yet, we reference that data source in the Web Console where we suggest a sample query to run: {code} Sample SQL query: SELECT * FROM cp.`employee.json` LIMIT 20 {code} The above query refers to the FoodMart data set. > Include internal data sets in documentation Sample Datasets > ----------------------------------------------------------- > > Key: DRILL-6667 > URL: https://issues.apache.org/jira/browse/DRILL-6667 > Project: Apache Drill > Issue Type: Improvement > Components: Documentation > Affects Versions: 1.13.0 > Reporter: Paul Rogers > Assignee: Bridget Bevens > Priority: Minor > > The Drill documentation provides the "Sample Datasets" section, which is very > handy. However, this section does not discuss the two datasets provided with > Drill itself. > * Julian Hyde's [FoodMart data > set|https://github.com/julianhyde/foodmart-data-hsqldb], available on the > class path. > * TPC-H data set, available on the class path in {{tpch}} > The "FoodMart" data set is available directly under {{cp}}. In fact, the > Drill sample query (see below) references a FoodMart table. To see the list > of tables (at development time), find the {{foodmark-data-json-0.4.jar}} file > in the Maven dependencies for {{drill-java-exec}}. The table names here are > simplified relative to those in the ER diagram in the above link. Perhaps > include a simple table with names, and the mapping to the original names, and > a link to (or just embed the link) to the FoodMart ER image. The data is > available in JSON format. > TPCH data is available in {{`cp`.`tpch/*.parquet`}}, in Parquet format. The > schema is described in the [TPC-H > specification|http://www.tpc.org/tpc_documents_current_versions/current_specifications.asp]. > These are very handy, but hard to find: I find I must keep searching the > source code to remember file names and directory paths. End uses won't have > this luxury. > Suggestion: Describe the files available in the class path data source. > Along these same lines, in "Connect a Data Source", there is no mention of > the class path data source. Yet, we reference that data source in the Web > Console where we suggest a sample query to run: > {code} > Sample SQL query: SELECT * FROM cp.`employee.json` LIMIT 20 > {code} > The above query refers to the FoodMart data set. -- This message was sent by Atlassian JIRA (v7.6.3#76005)