The challenge I have is the data was poorly formatted, here's some records
On Mon, Sep 21, 2015 at 2:14 PM, Jim Scott <[email protected]> wrote: > 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 > > >
