But that doesn't work either. Dreaded type change error.
On Mon, Sep 21, 2015 at 5:17 PM, Ted Dunning <[email protected]> wrote:
>
> One hack is to wrap each record with {"data": ... }
>
> That gives you something to grab onto.
>
> On Mon, Sep 21, 2015 at 12:53 PM, John Omernik <[email protected]> wrote:
>
>> Sorry about that, premature send. Here are some records. As you can see
>> the myvalue1-3 is in the top level of the record, ideally I'd run thte
>> kvgen on the myvalue records, but I have no way to address those. I tried
>> kvgen() on * for and that failed. Not sure how to address this in json,
>> yes, I know it's poorly formatted, but it's what I have been given.
>>
>>
>>
>>
>>
>> { "_id" : "127.0.0.1", "created_on" : "2014-02-18 14:52:23", "myvalue1" :
>> {
>> "source" : "somestuff", "context" : "Context here", "last_seen" :
>> "2014-02-11 00:00:00", "refreshed" : "2014-03-12 18:14:23" } }
>> { "_id" : "127.0.0.2", "created_on" : "2014-02-18 14:52:08", "myvalue2" :
>> {
>> "source" : "otherstuff", "context" : "Special context", "last_seen" :
>> "2014-02-26 18:14:05", "refreshed" : "2014-02-26 18:14:05" } }
>> { "_id" : "127.0.0.3", "created_on" : "2014-04-25 00:08:17", "myvalue3" :
>> {
>> "source" : "oops", "context" : "Other Context, "last_seen" : "2014-04-25
>> 05:32:08", "refreshed" : "2014-04-25 05:32:08" } }
>>
>> On Mon, Sep 21, 2015 at 2:52 PM, John Omernik <[email protected]> wrote:
>>
>> > 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
>> >> >
>> >>
>> >
>> >
>>
>
>
