I do believe KVGEN will meet your needs: https://drill.apache.org/docs/kvgen/
On Mon, Sep 21, 2015 at 2:11 PM, John Omernik <[email protected]> wrote: > I have some poorly developed json where the developer used data for key > names > > {"created":"2015-12-01", "ZYS":"BLAH"} > {"created":"2015-12-01", "ZYX":"BLAH"} > {"created":"2015-12-01", "ABC":"BLAH"} > {"created":"2015-12-01", "ADS":"BLAH"} > > I'd like to somehow map the key name to a value and give it a generic name > > select `created`, somemagic() as value1 from table > > Not sure how this would work, or if it's possible, or how I'd even > reference that, but thought I would ask. > > John > -- *Jim Scott* Director, Enterprise Strategy & Architecture +1 (347) 746-9281 @kingmesal <https://twitter.com/kingmesal> <http://www.mapr.com/> [image: MapR Technologies] <http://www.mapr.com> Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
