apache_phoenix.md 1.9 KB

A modern SQL Editor for Apache Phoenix

Background

Hue Phoenix Editor

This document is about the Hue specific improvements and assumes a running Phoenix server is available.

Tasks

The most crucial is to stabilize the querying API, improve the Editor assistant (Phoenix SQL Autocomplete) and make the full setup work out of the box.

[ Phoenix <-> Hue <-> User Browser ]

API

UI

  • Calcite SQL Autocomplete subset (grammar + builtins) (dev reference)
  • Left SQL assist panel
  • Trim the semicolon ;
  • Right panel UDF/Language references

  • HBase <-> Phoenix UX (simplify Phoenix onboarding, leverage current HBase integration)

    • Existing HBase tables need to be mapped to views
    • Tables are seeing as uppercase by Phoenix

Admin

  • CM CDP auto configuration of Hue properties (e.g. Phoenix service config)