Created on 03-20-2017 03:41 PM - edited 08-18-2019 04:17 AM
When I do a describe in phoenix (!table) a remarks field is displayed. How is this field populated?
Created 03-20-2017 04:43 PM
I assume that remarks field will be always be empty for your Phoenix tables.
This table description feature you are using is based on JDBC Metadata API.
Phoenix SQL does not support comments on tables, other SQL implementations may support that.
The JDBC Metadata API would return the table comment in the remarks field, (docs)
ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException
Retrieves a description of the tables available in the given catalog. Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE
, TABLE_CAT
, TABLE_SCHEM
and TABLE_NAME
.
Each table description has the following columns:
null
)null
)null
)null
)null
)null
)null
)See this discussion for further details. https://github.com/forcedotcom/phoenix/issues/183
Created 03-20-2017 04:58 PM
Thanks for your input. I am slightly confused by your response. Is there way to populate the REMARKS metadata via api?