luocooong commented on a change in pull request #2332: URL: https://github.com/apache/drill/pull/2332#discussion_r760832203
########## File path: contrib/storage-phoenix/README.md ########## @@ -0,0 +1,98 @@ +# [DRILL-7863](https://issues.apache.org/jira/browse/DRILL-7863): Add Storage Plugin for Apache Phoenix + +## Description + + Phoenix say : "We put the SQL back in NoSQL",<br/> + Drill call : "We use the SQL to cross almost all the file systems and storage engines",<br/> + "Cheers !", users said. + +## Documentation + +Features : + + - Full support for Enhanced Vector Framework. + + - Tested in phoenix 4.14 and 5.1.2. + + - Support the array data type. + + - Support the pushdown (Project, Limit, Filter, Aggregate, Join, CrossJoin, Join_Filter, GroupBy, Distinct and more). + + - Use the PQS client (6.0). + +Related Information : + + 1. PHOENIX-6398: Returns uniform SQL dialect in calcite for the PQS + + 2. PHOENIX-6582: Bump default HBase version to 2.3.7 and 2.4.8 + + 3. PHOENIX-6605, PHOENIX-6606 and PHOENIX-6607. + + 4. DRILL-8060, DRILL-8061 and DRILL-8062. + + 5. [QueryServer 6.0.0-drill-r1](https://github.com/luocooong/phoenix-queryserver/releases/tag/6.0.0-drill-r1) + +## Testing + + The test framework of phoenix queryserver required the Hadoop 3, but exist `PHOENIX-5993` and `HBASE-22394` : + +``` +" The HBase PMC does not release multiple artifacts for both Hadoop2 and Hadoop3 support at the current time. +Current HBase2 releases still compile against Hadoop2 by default, and using Hadoop 3 against HBase2 +requires a recompilation of HBase because of incompatible changes between Hadoop2 and Hadoop3. " +``` + +### Recommended Practices + + 1. Download HBase 2.4.2 sources and rebuild with Hadoop 3. + + 2. Remove the `Ignore` annotation in `PhoenixTestSuite.java`. + + 3. Go to the phoenix root folder and run test. + +### To Add Features + + - Don't forget to add a test function to the test class. + + - If a new test class is added, please declare it in the `PhoenixTestSuite` class. + +### Play in CLI + +```sql Review comment: @paul-rogers Thank you very much. Does it mean that the "sql" character can be removed? -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
