Hi,
Thanks for reply.
What i needed is custom serde that will serialize results of queries to JSON without empty fields. The serde can be configured using "hive.fetch.output.serde" (in Hive 10). It works well on console but it does not work in Hue (Hue GUI throws "Requested unknown parameter '2' from the data source for row 0").

Lukas

On 24.4.2015 09:01, Raunak Jhawar wrote:
Lukas,

This is more of a data modelling request. Can you create a staging table which will source all relevant data (on important columns) you desire to query and nothing more than that.

It would be more of a redundant job to add a NON NULL clause to subsequent queries, which is not a great design anyways.

--
Thanks





On Thu, Apr 23, 2015 at 8:28 PM, Lukas Nalezenec <lukas.naleze...@firma.seznam.cz <mailto:lukas.naleze...@firma.seznam.cz>> wrote:

    Hi,
    I have got complex schema with thousands of inner fields.
    Most of fields are empty and i would like to display only nonnull
    fields in results for each query.
    Is it possible to modify way the results are postprocessed ?

    Thank you
    Lukas



Reply via email to