With splittable system catalog you should be able to create views without
seeing performance issues.
Chinmay is working on enabling running a select query to return the
dynamic column values without specifying the dynamic column names and types
ahead of times.
(see https://issues.apache.org/jira/b
Persisting dynamic column names+types in Phoenix is exactly what views are
for.
On Wed, Dec 26, 2018 at 12:05 PM Vincent Poon
wrote:
> A lot of work is currently going into handling large numbers of views -
> splittable syscat, view management, etc... but agree that it's not ideal.
>
> There's
A lot of work is currently going into handling large numbers of views -
splittable syscat, view management, etc... but agree that it's not ideal.
There's currently no built-in way to do what you want AFAIK, but you can
manage the columns yourself in a separate table:
- store them all in a single c
Hello,
A user of mine brought up a question around dynamic columns in Phoenix today.
The quantity of columns should become asymptotic to a few tends of thousands of
columns as their data fills in.
The user want to query all columns in a table and they are today thinking of
using views to do th
