Options
Is it possible to explore this type of data with flex table
Hi ,
I have some files that contain unstructured data very similar to json but bot a valid json.
I want to be able to load it to vertica and explore the data inside.
I don't want to manipulate the files before loading it to vertica.
Here is a sample
TRe7245605-40d4-11e4-9f5f-00163ef51a20,{4:[52839,62513,62514],5:[3150958,3177945],12:[],20:[],28:[106624],66:[2814852],67:[2693522,2693525,2693533,3046072,3046074,3046091,3046093,3046095],105:[3047853,3047857,3047858,3047862,3057638]},false
TRe728ccbd-3d31-11e4-8277-00163e4e1292,{1:[],3:[2885296,3037737],5:[110507,3056029,3148037,3177945],12:[],34:[],38:[2560665]},false
TRe7292635-40d6-11e4-9f5f-00163ef51a20,{3:[],4:[],5:[100299,100309,100343,101121,3150958,3177945],28:[106595],32:[2659165,2659166,2659177,2659179,2659181,2659188,2659189,2659220,2659224,2659229,2659234,2659237,2659245,2659246,2659252,2659255,2659260,2659263,2659271,2659275,2659277,2659278,2659279,2659288,2716572,2716573,2716574,2716577,2716578,2716595,2716596,2716609,2716616,2716633,2716634,2752464,2752466,2752470,2752472,2752475,2752477,2752479,2752487,2752489],34:[],40:[111314,2430700,3176543],49:[2532311,2532325,2532362,2532384,2532554,2532610,2532649,2532665,2532692,2532744,2532797,2532816,2532828,2532895,2532950,2532959,2532973,2532979,2533037,2533211,2533365],62:[],66:[],67:[],105:[3047850,3047852,3047853,3047867,3057640],108:[3052549,3199420]},false
TRe7321769-3ee5-11e4-a256-00163ee2e1e7,{3:[2968624],4:[51109,57423,59032,59038,61794,62514,62592],5:[100002,100022,100024,100164,100230,100231,100232,100244,100245,100246,100247,100248,100250,100254,100263,100265,100266,100270,100278,100288,100309,100435,105747,105820,106265,106399,106904,3177945],9:[3047848],12:[103188],26:[],28:[106591],53:[2576224,3042815],54:[2594233,2624962,2624970,2625013,2625048,2625064,2625068,2625243,2625254],62:[],66:[],67:[3046074,3046087,3046094,3046095],98:[2927173]},false
TRe7334e61-3d1e-11e4-9235-00163e7109e5,{1:[56115,103138,2658991,3038473,3038495],2:[102713,102721],3:[102972,107751,107989,2646560,2646913,2801875,2801884,2801940,2802474,2884958,2968230,2968257,2968374,2968843,3036432,3036435,3036699,3036895,3036903,3037101,3037113,3037734,3038012],4:[62513],5:[100293,100309,2839938,2893202,2927167,2927181,2935793,2959108,3150949,3150958,3159767,3166750,3175868,3175887,3177945],20:[3057644],26:[],28:[106657],34:[],49:[2532232,2532257,2532285,2532289,2532295,2532367,2532370,2532383,2532384,2532390,2532392,2532401,2532405,2532406,2532413,2532427,2532439,2532456,2532492,2532503,2532514,2532518,2532564,2532619,2532648,2532665,2532689,2532692,2532698,2532710,2532722,2532727,2532743,2532768,2532793,2532802,2532813,2532822,2532828,2532850,2532869,2532879,2532881,2532883,2532895,2532928,2532973,2532979,2532983,2533053,2533082,2533141,2533147,2533153,2533163,2533178,2533272,2533282,2533290],54:[],55:[2689818,2689819],66:[3130833],67:[],85:[],110:[3124437,3124438,3124447,3124448,3124449]},false
TRe73c9341-39c3-11e4-b391-00163e6862ad,{1:[54241,54255,56111,56114,56115,56116,56118,56127,58122,58547,58548,58552,58554,58558,58574,58575,58576,58577,58580,58581,58583,58584,102844,102845,102855,102857,102877,102878,102879,102880,102881,103072,103073,103074,103075,103076,103077,103079,103118,103119,103138,108907,108911,108926,108930,108931,108937,108938,108963,2658968,2658981,2658991,2658998,2658999,2659000,2659046,2659069,2659070,2659071,2659072,2659073,2659074,2659075,2659076,2659080,2659113,2659115,2659154,2659155,2659157,2659158,2659159,3038384,3038409,3038413,3038415,3038416,3038417,3038420,3038421,3038422,3038423,3038424,3038425,3038456,3038457,3038473,3038474,3038495,3038498,3038499,3038504,3038505,3038507,3038508,3038511,3038512,3038513,3038514,3038515,3038516,3038517,3038518,3038519],2:[55305,55656,55705,55706,56022,58582,58614,58616,58618,58632,58634,102688,102689,102708,102709,102710,102711,102713,102742,102743,102745,102753,102754,102760,102763,102764,102765,102777,102778,102779,102780,102783,102789,102799,102800,102801,102805,102811,102813,107260,2659035],3:[58285,102171,102968,103065,103067,107162,107226,107227,107456,107497,107703,107710,107837,107989,107992,108041,108175,108313,108536,108636,111887,112046,112080,112267,112511,112542,112543,112804,112901,112976,112977,113097,113214,113260,113607,113643,2644988,2645055,2645314,2645495,2645581,2645627,2645874,2646111,2646139,2646348,2646373,2646376,2646377,2646378,2646509,2646574,2646578,2646766,2801542,2801654,2801882,2801946,2801947,2801948,2801949,2801956,2802270,2802325,2802429,2802430,2802431,2802432,2802565,2802633,2802885,2802917,2803230,2883908,2884457,2884496,2884500,2884653,2884793,2884794,2884885,2884886,2884887,2884948,2884958,2885276,2885277,2885278,2968552,2968614,2968674,2968830,2968835,2968836,2968837,2969144,3036433,3036699,3036892,3036903,3037018,3037053,3037061,3037103,3037113,3037167,3037172,3037334,3037367,3037411,3037432,3037507,3037508,3037534,3037642,3037683,3037684,3037685,3037686,3037733,3037909,3037936,3038012,3038103,3038179,3038227,3038237,3038241,3038318,3038319,3038347,3038364,3038365,3038366,3038368,3213133,3213134,3213137,3213138,3213140,3213788,3213868,3213871],4:[56791,56918,56952,58906,60496,60853,60861,61668,61841,62004,62005,62513],5:[100149,100177,100299,100303,100309,100316,100344,100345,100346,100348,100350,100394,100400,100449,103363,106347,106353,106437,106988,111438,2945988,2959073,2959075,2959090,2959092,2959108,2959109,2959133,2959351,2959631,2966221,3047918,3047920,3119816,3177945],12:[],20:[2984797,3057643,3057644],23:[55978,108337],28:[106645],35:[3124456,3150952,3152548,3152549,3152550,3152555,3152556,3152557,3152559,3152560,3152565,3152567,3152574,3152576,3152585,3152586,3152587,3152589,3152593,3152597,3152601],49:[2532247,2532250,2532251,2532257,2532264,2532280,2532282,2532285,2532289,2532295,2532313,2532329,2532341,2532352,2532367,2532370,2532374,2532384,2532401,2532405,2532406,2532408,2532410,2532415,2532450,2532456,2532458,2532474,2532485,2532488,2532506,2532519,2532545,2532562,2532579,2532581,2532601,2532609,2532614,2532615,2532648,2532649,2532665,2532668,2532670,2532689,2532698,2532728,2532739,2532786,2532791,2532797,2532813,2532824,2532825,2532861,2532878,2532883,2532915,2532946,2532974,2532979,2532983,2532988,2533006,2533015,2533059,2533070,2533073,2533082,2533147,2533149,2533166,2533204,2533232,2533249,2533282,2533306,2533362,2533399],55:[2689818,2689819,2689823,2689922,2689925,2689946,2689951,2689952,2689960],66:[2681601,2814851],67:[],102:[3222264],108:[2939120,3052558,3199420],110:[3124437,3124438,3124447,3124448,3124449],120:[3197740]},false
TRe7417d06-3a2f-11e4-8b32-00163e0b32e5,{1:[],2:[],3:[3037685,3037686,3038017],4:[62513],5:[103366,103368,2902425,3175887],12:[],20:[],28:[],34:[],35:[],62:[],66:[2814848,2814852],67:[2693522,2872501,3046064,3046066,3046087,3046092,3046093,3046094,3046095,3168808],102:[2976247,3222264],105:[],108:[2939106,2939113,3052558,3199438],110:[3124448]},false
TRe7445fd6-3ce6-11e4-b188-00163e9caa2d,{1:[103138,108937,3038495],2:[102713],3:[2801879,3037685,3037686,3038017],4:[],5:[3038618,3175887],12:[],20:[],23:[],24:[],28:[106591],33:[3129825,3129855,3129910,3129919,3129920,3129936,3129937,3129938,3129942,3129972,3129992,3130040,3130041,3130079,3130090,3130092,3130120,3130229,3130230,3130231,3130244,3130245,3130246,3130247,3130249,3130258,3130259],34:[],55:[2689967],66:[],67:[],86:[],97:[],102:[3189790],108:[2939113,3052559],121:[3197713]},false
Any Idea how can I load those rows to Vertica ?
Thanks
I have some files that contain unstructured data very similar to json but bot a valid json.
I want to be able to load it to vertica and explore the data inside.
I don't want to manipulate the files before loading it to vertica.
Here is a sample
TRe7216edb-3c77-11e4-ae6e-00163e9d6693,{4:[],5:[100235,100282,100299,100309,100343,100344,100348,100360,103363,103366,103367,106347,2911203,2911227,2959075,2959090,2959092,2959109,2959287,3038618,3175868,3175887],12:[],20:[],24:[],26:[],28:[106618],54:[],66:[],67:[],68:[],105:[],121:[3197730]},falseTRe721f5df-3f30-11e4-a256-00163ee2e1e7,{1:[],2:[],3:[3038017],14:[],23:[],33:[109099,109104,109105,109106,109107,109108,109109,109110,109114,109117,109118,109119,109121,109122,2627680,2627682,2627683,2627698,2627699,2627700,2627702,2627703,2627704,2627705,2627706,2627707,2627709],34:[],40:[],53:[],54:[],66:[],86:[],105:[]},false
TRe7245605-40d4-11e4-9f5f-00163ef51a20,{4:[52839,62513,62514],5:[3150958,3177945],12:[],20:[],28:[106624],66:[2814852],67:[2693522,2693525,2693533,3046072,3046074,3046091,3046093,3046095],105:[3047853,3047857,3047858,3047862,3057638]},false
TRe728ccbd-3d31-11e4-8277-00163e4e1292,{1:[],3:[2885296,3037737],5:[110507,3056029,3148037,3177945],12:[],34:[],38:[2560665]},false
TRe7292635-40d6-11e4-9f5f-00163ef51a20,{3:[],4:[],5:[100299,100309,100343,101121,3150958,3177945],28:[106595],32:[2659165,2659166,2659177,2659179,2659181,2659188,2659189,2659220,2659224,2659229,2659234,2659237,2659245,2659246,2659252,2659255,2659260,2659263,2659271,2659275,2659277,2659278,2659279,2659288,2716572,2716573,2716574,2716577,2716578,2716595,2716596,2716609,2716616,2716633,2716634,2752464,2752466,2752470,2752472,2752475,2752477,2752479,2752487,2752489],34:[],40:[111314,2430700,3176543],49:[2532311,2532325,2532362,2532384,2532554,2532610,2532649,2532665,2532692,2532744,2532797,2532816,2532828,2532895,2532950,2532959,2532973,2532979,2533037,2533211,2533365],62:[],66:[],67:[],105:[3047850,3047852,3047853,3047867,3057640],108:[3052549,3199420]},false
TRe7321769-3ee5-11e4-a256-00163ee2e1e7,{3:[2968624],4:[51109,57423,59032,59038,61794,62514,62592],5:[100002,100022,100024,100164,100230,100231,100232,100244,100245,100246,100247,100248,100250,100254,100263,100265,100266,100270,100278,100288,100309,100435,105747,105820,106265,106399,106904,3177945],9:[3047848],12:[103188],26:[],28:[106591],53:[2576224,3042815],54:[2594233,2624962,2624970,2625013,2625048,2625064,2625068,2625243,2625254],62:[],66:[],67:[3046074,3046087,3046094,3046095],98:[2927173]},false
TRe7334e61-3d1e-11e4-9235-00163e7109e5,{1:[56115,103138,2658991,3038473,3038495],2:[102713,102721],3:[102972,107751,107989,2646560,2646913,2801875,2801884,2801940,2802474,2884958,2968230,2968257,2968374,2968843,3036432,3036435,3036699,3036895,3036903,3037101,3037113,3037734,3038012],4:[62513],5:[100293,100309,2839938,2893202,2927167,2927181,2935793,2959108,3150949,3150958,3159767,3166750,3175868,3175887,3177945],20:[3057644],26:[],28:[106657],34:[],49:[2532232,2532257,2532285,2532289,2532295,2532367,2532370,2532383,2532384,2532390,2532392,2532401,2532405,2532406,2532413,2532427,2532439,2532456,2532492,2532503,2532514,2532518,2532564,2532619,2532648,2532665,2532689,2532692,2532698,2532710,2532722,2532727,2532743,2532768,2532793,2532802,2532813,2532822,2532828,2532850,2532869,2532879,2532881,2532883,2532895,2532928,2532973,2532979,2532983,2533053,2533082,2533141,2533147,2533153,2533163,2533178,2533272,2533282,2533290],54:[],55:[2689818,2689819],66:[3130833],67:[],85:[],110:[3124437,3124438,3124447,3124448,3124449]},false
TRe73c9341-39c3-11e4-b391-00163e6862ad,{1:[54241,54255,56111,56114,56115,56116,56118,56127,58122,58547,58548,58552,58554,58558,58574,58575,58576,58577,58580,58581,58583,58584,102844,102845,102855,102857,102877,102878,102879,102880,102881,103072,103073,103074,103075,103076,103077,103079,103118,103119,103138,108907,108911,108926,108930,108931,108937,108938,108963,2658968,2658981,2658991,2658998,2658999,2659000,2659046,2659069,2659070,2659071,2659072,2659073,2659074,2659075,2659076,2659080,2659113,2659115,2659154,2659155,2659157,2659158,2659159,3038384,3038409,3038413,3038415,3038416,3038417,3038420,3038421,3038422,3038423,3038424,3038425,3038456,3038457,3038473,3038474,3038495,3038498,3038499,3038504,3038505,3038507,3038508,3038511,3038512,3038513,3038514,3038515,3038516,3038517,3038518,3038519],2:[55305,55656,55705,55706,56022,58582,58614,58616,58618,58632,58634,102688,102689,102708,102709,102710,102711,102713,102742,102743,102745,102753,102754,102760,102763,102764,102765,102777,102778,102779,102780,102783,102789,102799,102800,102801,102805,102811,102813,107260,2659035],3:[58285,102171,102968,103065,103067,107162,107226,107227,107456,107497,107703,107710,107837,107989,107992,108041,108175,108313,108536,108636,111887,112046,112080,112267,112511,112542,112543,112804,112901,112976,112977,113097,113214,113260,113607,113643,2644988,2645055,2645314,2645495,2645581,2645627,2645874,2646111,2646139,2646348,2646373,2646376,2646377,2646378,2646509,2646574,2646578,2646766,2801542,2801654,2801882,2801946,2801947,2801948,2801949,2801956,2802270,2802325,2802429,2802430,2802431,2802432,2802565,2802633,2802885,2802917,2803230,2883908,2884457,2884496,2884500,2884653,2884793,2884794,2884885,2884886,2884887,2884948,2884958,2885276,2885277,2885278,2968552,2968614,2968674,2968830,2968835,2968836,2968837,2969144,3036433,3036699,3036892,3036903,3037018,3037053,3037061,3037103,3037113,3037167,3037172,3037334,3037367,3037411,3037432,3037507,3037508,3037534,3037642,3037683,3037684,3037685,3037686,3037733,3037909,3037936,3038012,3038103,3038179,3038227,3038237,3038241,3038318,3038319,3038347,3038364,3038365,3038366,3038368,3213133,3213134,3213137,3213138,3213140,3213788,3213868,3213871],4:[56791,56918,56952,58906,60496,60853,60861,61668,61841,62004,62005,62513],5:[100149,100177,100299,100303,100309,100316,100344,100345,100346,100348,100350,100394,100400,100449,103363,106347,106353,106437,106988,111438,2945988,2959073,2959075,2959090,2959092,2959108,2959109,2959133,2959351,2959631,2966221,3047918,3047920,3119816,3177945],12:[],20:[2984797,3057643,3057644],23:[55978,108337],28:[106645],35:[3124456,3150952,3152548,3152549,3152550,3152555,3152556,3152557,3152559,3152560,3152565,3152567,3152574,3152576,3152585,3152586,3152587,3152589,3152593,3152597,3152601],49:[2532247,2532250,2532251,2532257,2532264,2532280,2532282,2532285,2532289,2532295,2532313,2532329,2532341,2532352,2532367,2532370,2532374,2532384,2532401,2532405,2532406,2532408,2532410,2532415,2532450,2532456,2532458,2532474,2532485,2532488,2532506,2532519,2532545,2532562,2532579,2532581,2532601,2532609,2532614,2532615,2532648,2532649,2532665,2532668,2532670,2532689,2532698,2532728,2532739,2532786,2532791,2532797,2532813,2532824,2532825,2532861,2532878,2532883,2532915,2532946,2532974,2532979,2532983,2532988,2533006,2533015,2533059,2533070,2533073,2533082,2533147,2533149,2533166,2533204,2533232,2533249,2533282,2533306,2533362,2533399],55:[2689818,2689819,2689823,2689922,2689925,2689946,2689951,2689952,2689960],66:[2681601,2814851],67:[],102:[3222264],108:[2939120,3052558,3199420],110:[3124437,3124438,3124447,3124448,3124449],120:[3197740]},false
TRe7417d06-3a2f-11e4-8b32-00163e0b32e5,{1:[],2:[],3:[3037685,3037686,3038017],4:[62513],5:[103366,103368,2902425,3175887],12:[],20:[],28:[],34:[],35:[],62:[],66:[2814848,2814852],67:[2693522,2872501,3046064,3046066,3046087,3046092,3046093,3046094,3046095,3168808],102:[2976247,3222264],105:[],108:[2939106,2939113,3052558,3199438],110:[3124448]},false
TRe7445fd6-3ce6-11e4-b188-00163e9caa2d,{1:[103138,108937,3038495],2:[102713],3:[2801879,3037685,3037686,3038017],4:[],5:[3038618,3175887],12:[],20:[],23:[],24:[],28:[106591],33:[3129825,3129855,3129910,3129919,3129920,3129936,3129937,3129938,3129942,3129972,3129992,3130040,3130041,3130079,3130090,3130092,3130120,3130229,3130230,3130231,3130244,3130245,3130246,3130247,3130249,3130258,3130259],34:[],55:[2689967],66:[],67:[],86:[],97:[],102:[3189790],108:[2939113,3052559],121:[3197713]},false
very close to json but not valid so the json parser fail.
Any Idea how can I load those rows to Vertica ?
Thanks
0