Support Questions

Find answers, ask questions, and share your expertise

Cannot read Parquet format generated by Spark

avatar
Explorer

Hello,

I've just installed CDH5.2.1 (Debian 7.1 using Parcels), I thought IMPALA-1401 fixed this. I've got the following error in Impala when trying to read a Parquet file :

10:02:40.833 AM    INFO    plan-fragment-executor.cc:301    
Open(): instance_id=9446af1516dfafd2:4b903485559cd693
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: Ba49381ca2f6c691_1415618888645_47fd7d2b-0eec-3527-ab62-6f009307d1c6nF�90262_76b14f3f-9b7a-3ac8-8748-a78441e1e0b3Bj��91829_9285dd4f-1ef4-38b6-a4e1-d028b3085d68BnF�3495_2ee0dd52-c4f0-3fb2-a7aa-d0f7050e7f4df��9251772_302420f1-43fb-3bbf-a83a-dd76f3246d9fBb��9253134_a45a1198-1594-317b-b29f-5e836b0173b7BnF�4275_5a60a6da-0a26-3c72-9fa4-c78fbcae7097r��5431_8d0a4395-8768-3e50-b3ad-d3ed3781c837nF�89677_1ecebe43-5677-32db-825e-cf14ef79eb6j�)
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: ��,�Bimpression-hash_1417172009391_4ce37995-ec69-3165-82a6-28b8921a9e8bBa49381ca2f6c691_1415618888645_47fd7d2b-0eec-3527-ab62-6f009307d1c6���L�Ba49381ca2f6c691_1415618888645_47fd7d2b-0eec-3527-ab62-6f009307d1c6nF�90262_76b14f3f-9b7a-3ac8-8748-a78441e1e0b3Bj��91829_9285dd4f-1ef4-38b6-a4e1-d028b3085d68BnF�3495_2ee0dd52-c4f0-3fb2-a7aa-d0f7050e7f4df��9251772_302420f1-43fb-3bbf-a83a-dd76f3246d9fBb��9253134_a45a1198-1594-317b-b29f-5e836b0173b7BnF�4275_5a60a6da-0a26-3c72-9fa4-c78fbcae7097r��5431_8d0a4395-8768-3e50-b3ad-d3ed3781c837nF�89677_1ecebe43-5677-32db-825e-cf14ef79eb6j��9295510_560879bc-6c7e-37a0-8439-5b000ad1a3fbBjh98316_e8d89936-608b-3f59-81A0(3def0143641j�T300723_4b5d8199-70e0-3A�@a6c9-dde0f6c37f8ebF�29993017_f6e888b7-c0b2-3c57-8b10-74daa6a840f1rFD4341_094e3dbd-104d!H2-8c55-eb646e4064cdrF<5506_fe2b6aaf-df�L186-8b85-a5af1de688bf�86775_9871da4d-5IvH14-b03a-2d76c0bc527f��30031187_7f41cf78-95b0-358b-88f7-0ca0a19e7f82b�F�6705_12eb6ec3-092c-3f93-b576-1160e4fd7526rF�9796_e300b390-33b8-361f-bd2c-48f24ef2455enFH42361_9d4bda69-dbd2�H1-8661-c43cc8488186fF@3969419_66169e5c-a    T-382d-85b3-a3f8c0159b5f�33971094_32213461-a7b6-32f7-864c-e8724a101b5dn��72635_aa03e13a-4ea4-3b95-9b0b-9a8335154b7f�<4328_d172a607-e5!�L129-abab-190a72d03b6j�4389145_9b087f0f-0a33-364b-b67e-834aab7b1d3f��34390507_34e28d3c-c47d-3c6b-948b-ecbb3a6057nv�4392322_9640c565-6ea0-3406-a884-a3de386fe1baB^�FD3487_8fdf4854-9166��D7-8f98-c22f3124149fJ�34426194_710508ae-c11b-338b-aac6-f48b89fca77ff�4!�65_74a�te2-470a-3bdf-883e-c26be4fe570crF�5351_cfa13c3d-beaf-3e9b-9b8f-f76ad5eb2b1drF�8221_d50e74bf-4a11-38f6-beb7-0408a9f07dfx�784828119_cc606868-5ad6-3658-b327-07581b2f0c6bHF!��_534ba48c-9c23-39e0-8b64-d1e5b1bea6e3^�F�30863_f65e932f-6409-3ae5-97ae-022103e51c5b�F�2106_874b4458-09f2-3edb-a566-fd0b!�6f7b�F�72658_e45fa741-2fde-366f-9856-75f5376dadcbJFD9256_79e0b29d-36c0FH0-ae4c-fae5e996ed85n82565_d9r
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �85�J<becd684a-25f5-31�8890-0b01e230f44b�78519324�)
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: f9-dc2��H74-992e-69d205fa168bH�85�J<becd684a-25f5-31�8890-0b01e230f44b�78519324�
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: 85194602_c965771/`c6-3a85-9554-f6a5eeb21c72f)
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 271b1��\bc-3ad9-842c-76caf666b95j^85194602_c965771/`c6-3a85-9554-f6a5eeb21c72fL5195766_e571ed5f-16daHcf-b56 f31b02492z�86925_c7ba3e53-2r T37b4-80ce-ff04d3e962c0j��232566_641a409f-bb29-3f21-abd8-5699890c!znF�42102_fcfb6ea1-fb52-3daa-bb92-ab9ad6d8842b
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: FD4-9e5d-63f81533f80fH�91309587_c67c08bb-7b69-3293-9f9a-dbcd149fa0f0b��91311482_1c09446f-17ee-343b-8714-743362293dd5rF<3078_aede8a49-b7    ,2bd-92a2-785�� d2b6f�)
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 785244��0aeb0409c-401cFD4-9e5d-63f81533f80fH�91309587_c67c08bb-7b69-3293-9f9a-dbcd149fa0f0b��91311482_1c09446f-17ee-343b-8714-743362293dd5rF<3078_aede8a49-b7    ,2bd-92a2-785�� d2b6f��473�
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: X92359438_1e601a5a-5470- -b)
10:02:40.942 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: <b833-492dd3263eaf�X92359438_1e601a5a-5470- -b
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �2363116_3a522216-3e57-37ed-aa36-faf5649fc55f�P92397360_4ae017cb-1b3� H63-b2ff-c63f4792011j�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 'afd749efT92360697_771900f6-52a8�bd��,0-6e1dbb8451f| F�1960_516f47c9-9c61-3477-9d38-c6c9247adeecf^�2363116_3a522216-3e57-37ed-aa36-faf5649fc55f�P92397360_4ae017cb-1b3� H63-b2ff-c63f4792011j�P2403302_ad21c446-8495�3-,-751691aec2dj�H2406372_6857350b-86�    @877-b4ad-65a401e4�j0409218_d826c2
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F411756_1f87a1d5�T0-37f0-b1f1-e4c4707007f�FD4289_b8a9d799-a9e9�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 76c3b�F411756_1f87a1d5�T0-37f0-b1f1-e4c4707007f�FD4289_b8a9d799-a9e9�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F<4848_197711ce-8a~5ad86-4a�e3ca3bbFD6036_261817f2-5be6)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 8F<4848_197711ce-8a~5ad86-4a�e3ca3bbFD6036_261817f2-5be6�6�20b-dea3cc970fdfH��7188_994536cd-7974-3fd1-bfc3-5bbc321c43c7n,50950_a1a022L9a6-3d18-b8c0-7abf8f��bx�568�$7960a4-e93!^Hcd-8e26-276428173dafH6A�H593_ab97bb27-cc08-39d��bb�T4c6v�$62288_08c9�d-beed-302f-9a23-af6a9c86fbj�94313557_a8c948d3-3a25-325d-81aa-48f0221c7ecfb^F$5764_361e7A�620aH�    83c7-f718a1af008f�F07186_a88f34fe�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F@8896_827e68cc-39fAvH3a-8578-67e967fc2beb�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 2464887f�F@8896_827e68cc-39fAvH3a-8578-67e967fc2beb��952875512_759594c3-b230-3aff-a297-621fdbdd4f7b�F`7247_a42a5489-ee37-3b82-8(38ed3e3128fbHF08808_d6c825c70X4-3d30-b19b-2654e2da05dbF�80324_ca03d60d-c463-3dc0-8091-8d93aa1958cb<953654597_e7ca20Aqd�97eN ,2-7ddbf7d849n�43656528_0109b7��5A�9b��073-de8093cf02f�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: L3659727_c94b220a-cea8b4024-4224d999c2f� 9537��8_b9be9c25-d67f-34df-96f2-45447142388jvP3731519_ef4d9777-1ae7��D4-86ef-214c382cedabH)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: �@8102_3e838a6d-8c2L    b5~0d-0def9f6131fj�L3659727_c94b220a-cea8b4024-4224d999c2f� 9537��8_b9be9c25-d67f-34df-96f2-45447142388jvP3731519_ef4d9777-1ae7��D4-86ef-214c382cedabH�3�,_fe116e01-5b�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �62�,25e5cb23-5f8h$73-8f7d-94�e4ce9b)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: L52a-aa5b-a1f03c76ae6bb�62�,25e5cb23-5f8h$73-8f7d-94�e4ce9b
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �T1-3f31-921e-40ae84bbf3fF6197_8pp360-c7b7-3896-9c3c-50e0c8905dz�(7369_35971b;179�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: F<4370_31b2e0f4-11:717-907��c2c2617cf�T954413402_ecd2846d-561m� 8b06��62d744f�    F05039_3fceddc6�T1-3f31-921e-40ae84bbf3fF6197_8pp360-c7b7-3896-9c3c-50e0c8905dz�(7369_35971b;179�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 8-97a294ca3n^J��46_1707b72d-f7f����84b7-dcf52ff756ab"F<6872_7a0d0210-cf!L304-a085-c675fb1a6eab| Fh0_38463468-e7b�Heb-8d40-dc303663092b�F462136_66cf27ca�86-34be-ba63-29e� f2e4n� 7881 60db019-5�5af(0c-88b00213798b�(954789568_ff00a-e47�fa-a2Debd63Z0j�D4790712_9e1d1400-4�O3c67-a57 f606b91e0j�L4791869_9841b78c-c31�x0�� 9e7091ca3rHH809271_f3b464ef-eb9:063-a7eb-3f211�3f�$954810909_A� ad61-65e1aa0c-d94afb43725n�812486�06ea55-258c-38a95-2355a�651b��T4099_33374664-4dbb-394$419-b5d01ff07f7j��4825451_34523483-a972-30b1-b7a9-4ac1246d832n�831R(6bbf2383-4ca�<f6a-8a57-e8fb721�J9j�4834058_1467603��@44-8c1d-6d0fa2e9arJL4836523_798270a1-2e6���scc2-c58a� 4c95j    52C04_2b8a4d50-764b5V4ad-fd9aa89f9b0j4520�O_527e3�i63h0a03-8fef-68ca�51nxP5204769_7e4269dd-c84e
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F�(_6b9bc348-3�2e6-ae�" c7b8d7a78v�70�565892�c�!1��4350-504a6dc538nxD8909611_b665e3de-8�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record:  4a9e26762j525�0_2fe7b316-e16��Ha2-91ba-51aab447eb4v�@7152_558a5ce9-756�27(ad45db6d89cj�    H8867061_4bbc50e4-ae| 9<8682-deca4895b49j886A�<_2c2b3c94-cf4f-3!b18{faadeb2f~9F�(_6b9bc348-3�2e6-ae�" c7b8d7a78v�70�565892�c�!1��4350-504a6dc538nxD8909611_b665e3de-8�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F540� 0bb0�140�2-84ad=2e0d024df�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 820-f387efdd9f6cb2F540� 0bb0�140�2-84ad=2e0d024df�F(6983_31952f&�3e0� 8b-4d4A� d82bf�F87� 22d��0d,69-8ac0[ 85d78c9fdf�3913_3a55a!Y0e�c53�cd0709�rF89915_09e01f06-7�L671-bbd7-b6f23d467adr�@21540_659b3afd-55$ 53d-�,-2b2937b08ccf�6�6 ,b8fd0662-4e6�b497-c61d62c500ajF@4394699_68fa966a-�&-38760e-0648445be0afHFd6353_96f84efd-f201-31f2-bd!'!876224b!F75N 71bb4de-��-�%@-9125-223bd1020c6j0P4398893_b172fbff-65caa�80-82b3-d4160c1f� f�44437862_cd0dfc�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F5�,6d875212-5f7!^Hd3-9421-d1da14a7d97j�H5297249_55a25dd8-c9�Lad3-ae94-1998dde117djv52 04_0d10e086-08�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 4f44f4F5�,6d875212-5f7!^Hd3-9421-d1da14a7d97j�H5297249_55a25dd8-c9�Lad3-ae94-1998dde117djv52 04_0d10e086-08�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F7�eae05��1�&Lfeb-ad95-c5e0759ef79v�<8297_670c9f41-3d�)fl6 $9411f890a1f�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 6534457l 97fa71-5c�L0aa-9838-66449bd7038j05�C(12_5ff6bf8e�1-�<-9ff3-2df41bcc4cf�"�9�H083fb12b-d36e-3ff5-O -d5325341Ab0L73395624_de5edb7d-0c~H52-b526-403e9910c6efHF7�eae05��1�&Lfeb-ad95-c5e0759ef79v�<8297_670c9f41-3d�)fl6 $9411f890a1f�� 9412�'9f67b-7c�P<a980-9973e09909df�7532626�$61f20e-78d�Dc-b8e2-524db596911vFp7970_9a7708b9-a1d8-35de-b90b-�238afe2vF94X04e90e6c-c8cf-!�-9c34!^31da6c88f�753� H9_643630f0-4649-3cc.f5-f7c61jb*P977318097_0b813b66-8c�*c��(6a9-d4e8e74-f�F@9384_8346d046-2ebd-H0b-b5b4-d228f0c2a64f77320576J)$522c0-c28d�b�(410b4229c78r�2"
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: X7371757_5640e756-0397-3� a�#36 (7f�    BZ�'! 7469� )
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: (e3-92f8-c87�� 57abj�73625�@9cb69be-3bfa-3ca8V07-0e1e1831b5cj�X7371757_5640e756-0397-3� a�#36 (7f�    BZ�'! 7469� #32-10a�69e-9     $896ead3924fd-F7195_�  f3f8-83e9�Db-be62-fbe5f6ee6def
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: }`4c87-3c7b-a59d-ca7ddcb93efF 4326_c1e1E�5cTL2e0-9c01-088ff23e78bn^)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 477602669_cdb85}`4c87-3c7b-a59d-ca7ddcb93efF 4326_c1e1E�5cTL2e0-9c01-088ff23e78bn^H605514_8dffc53e-90585c-810d-da38856 n^4606755_c99c8b0��&c9c-91c0a�451eeb6n�H7647044_6e2a9f30-6b
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: 80#021_36e42cc9-6�73dcf-a�.$f47db898d2f!FT8594_e87d8fd6-ee73-3de)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 881��04-89e2fb13c1cf`L80300920_d1f296a8-e9��c6c�(L    $54ef8e1d3ab�80#021_36e42cc9-6�73dcf-a�.$f47db898d2f!FT8594_e87d8fd6-ee73-3de�3|2b7b5fd
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F!K,_388dd05d-93,0 09a-e0e1038609b�    T6216995067_5924ea40-72�Lc6e-8784-d57437e00f8^�    F6477_7)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 803513�'<d49efc6-2bcc-3f7�044-04e12ee7c4j�F!K,_388dd05d-93,0 09a-e0e1038609b�    T6216995067_5924ea40-72�Lc6e-8784-d57437e00f8^�    F6477_7_-e98�.d-8247-�ab1642b,    F,7753_ac7e157�e�4(3d-9eab-54c�"b19b0    F9008_8�!aa�b�8b8b8-fdecca6682bbD6217039151_e14e04b�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �19a-b4)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: T37-3aed-bd59-aadde4794f�F,.03_fb2b2aa1-45!�4d9c-be31-e18dck#0b�F51j(7af0f432-39�19a-b43adfa7c�Z    Fi0�_568e00bf-7ef8-3fe2-a3bb-bd4f3c6a815ebF2�#53�2026b34-2&P3922-bf18-739d1e27f71f0Fd8327_6912fac2-61e2-383c-b7
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: FL127475_6ac56fdd-692b�+0-8��3d84e6)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record:  $77ec035761^l<780154_e537e8af-�-35a1-b�(a2b40cba3a1^�    FD1661_05b16561-490d�'Dc-9915-3ea08cde057^L    |6225082826_891b3103-7d83-3cda-a4�557d11 5^�    F@4198_0c24a2d2-6de�`H2f-a407-ad20bb198a1vF5545_�c4�     bd5-3054-�.,-d1c0025c56b^2    �06764_981f998f�-�!0bv7-477�"d0eb�-FL127475_6ac56fdd-692b�+0-8��3d84e6�r�D134855_49acc05f-79�88cc!^d-ba09a8!686f�45137393_43fee4�c0f00�43b-23cb12edfb7^��398@dcb742�4� fb�3fA�895�6jv56972'f89309bq4a-3� 88f09-d541d40b44bV�0698814_5a5fc6d-5�Hee2-9e6c-7879d2f0acb"3F70011/aacd9d-�P-3e38-bf7c-06dcc751ccb�!    F1�#51094p+932(�<b998-bac8d3fcd55^jF 4294�� 03be30-1f�,<a8f-98e4-5466535�^�F<51976_f1515fb3-e~8T4�!(4b4737407c5j0 754695_b3�-4e�F 81af���nv4757338_4f0c5420�2�!�l$f810bab370b2(<6307036363_4f6be�46b�34f-a35� 991f58503b^F79�$ec58193-77$6e�-87d3-b634ab75186b^F936. 198eA&5�:364j69�1ccdc5fdb�)FH41141_6eeaa9eb-2176(<bk0(d0c216aeb2eb�4307802266_5455)195)�� 8332�3eb3�#eb�F~.`_678927a0-24f6-3758-9dff-T; 3d56�:^0F5333_1bbA� e-63v%e�.4eb$6q 53b�$    F$6754_d00e4~9b��9e,425-1c7141a8c7bj�H8130964_51487c4f-43���8a26c-64141e98c6b�63F82293_e12b7538-8k
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: 883_26C 0e-89�90b6-807�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 2$bf4c6b4e-72�&484-ee5c755260fb�D309714847_3cdb322a-��b0<?%9986e61bb."    F623:d0�0-f2d4-3687-bd]>61�' 131c^j    F87442_35faf9a2-4�3�/aA:b5&6a072b�    �08735_dacceb88�>�)P8f00-534d60027c6n�9723746 7daa770e-3c45> b-452 2796j�883_26C 0e-89�90b6-807�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F85273_fab134b0-5}<3423-bf65-000f9f�#b�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: d7611b85f�3F85273_fab134b0-5}<3423-bf65-000f9f�#b�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F06531_129dda60�X�%3e�8-b55565�@b�    �@7787_22cb5660-fdd"348-a6b9-�    36570b 0    F@9078_f4a74e23-42a�D8a-8617-015b919f86f )
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: h310525276_aadc64aa-d812-34e�3478-22f54bba48df`F06531_129dda60�X�%3e�8-b55565�@b�    �@7787_22cb5660-fdd"348-a6b9-�    36570b 0    F@9078_f4a74e23-42a�D8a-8617-015b919f86f
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: ,43-G78378e6^�    F�)_d1e7766>:�Hf8b-977e-1349f764a6b�    F<6340_1b72314e-df�Jaf�*00d-aaa8697b55b>    F�0,_cdf737a1-08�<34*?42a-957d53c828df4814738581_06d246�"o3D8e�6c8a6a75f*)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: a45 93�;c-3489-9m3$036f60e36db�D6314373767_e17f3c4�da�f,43-G78378e6^�    F�)_d1e7766>:�Hf8b-977e-1349f764a6b�    F<6340_1b72314e-df�Jaf�*00d-aaa8697b55b>    F�0,_cdf737a1-08�<34*?42a-957d53c828df4814738581_06d246�"o3D8e�6c8a6a75f*�739902_�173se`'bae-a18�( 72bcf00fe^lF041182_a8dc6efAaH$39d-90ca-5�;be777f��42b*<ad57df58-8924-30    9�$753b412606b�4881060� 2ba7bc�&4D 6-8L(e1cda65367eb~F<7485_122278a1-2b�}(884d4-a19afe0d9eb�    F88� 03e�3�9>a3�,f-07e36a6be2f��10059_�49462-36a(b77-eb80452     b�8839273888_cbdc5aC4d�;795�1,6-2f0b16b9c1bB    F _aca46zd6121-3e2b-9b93-ec8d8f1d0bfb��T7358_a602e65c-1f56-3d1��08c-1e9f38f976b�&    F(8923_59c1f7?/0�6Lccd-b399-283ff45cec3b�8839954020_42158*2bf
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: 2a4c50abn<    F�APe9128���42f-20d422fa2fab��07146_6a53a044� 7�C8a60f-514041c0e2fN F,8742_cc2eac2a��299a-b2O79556e�=b<841204130_e33ffa!2<956-8?8'bZ;f8b)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: dpb52a4c50abn<    F�APe9128���42f-20d422fa2fab��07146_6a53a044� 7�C8a60f-514041c0e2fN F,8742_cc2eac2a��299a-b2O79556e�=b<841204130_e33ffa!2<956-8?8'bZ;f8b
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �<4650_0fc2d902-c9�5fe4-8�'$4b6257f610b,B    �5763_["�% -e6a�    86-aa6�'91!)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: F�)511dc�(d6�HA7<90e3-f59463fd0aeb�FL6599_838d252f-cb28-3]*8a817-c51c9ebf31z�(7897_46572d96f�    e9-8b�($a83f418984b P842022004_5cbb3852-96FF(7e7-a486-dc(�bv%    F338!� 125c16-46$60948-8659-6edc!v47df��<4650_0fc2d902-c9�5fe4-8�'$4b6257f610b,B    �5763_["�% -e6a�    86-aa6�'91!
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F�D@5_c182cee3-414a-3�    bf57-2f7& 4a1dj�D4315348_65bea501-7�e0� 4ea-77f0135fc4ff`)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 4b>f7��06d7de�(1b6 844187 cdcbf� a6�H387-a923-daf5508c4ffJF09054_3d8bea43jE�59f-99d5A�0530c03b~1F�D@5_c182cee3-414a-3�    bf57-2f7& 4a1dj�D4315348_65bea501-7�e0� 4ea-77f0135fc4ff`F86924_be151bdc-2�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: D318559_50b3bf61-ae�8f12-98c2-80514d�+n04491590_39e23c2T8X47<7� 4cf4�b5jL4493543_0324e61c-ee0�5c-�03e3400b�*!�495�3$7c4a61cc-d+9341a-b4a�$cae450db71b 8)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 3b09�]$55a1fa3b1bj�D318559_50b3bf61-ae�8f12-98c2-80514d�+n04491590_39e23c2T8X47<7� 4cf4�b5jL4493543_0324e61c-ee0�5c-�03e3400b�*!�495�3$7c4a61cc-d+9341a-b4a�$cae450db71b 8�66�C482d21�*096-326e-81b7-y+65f68b9b�90## 74_a
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: FH800579_811fdf67-f83,B�4498-7042�8br)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: F7367_d`32bb-163�C37���> 007104f0dvF(8968_db1bac�2b�A{<8508-5af97bc2549b�     902798082Bx36fd7-c0ad-3122-89f3-db67d309d2b�A    F93vH d2734f0!^71d�>9-cY'53cc4b,FH800579_811fdf67-f83,B�4498-7042�8brD801827_ba8b13e5-a2a9aCa� $3a2756f812b�2)_1358d�28!c6�,aeb-0f3f297f\L^�F 4448_46ee�-fc�29�-�(eb0a7f32dbcf�186Z3_758e32df<@9bf-8e43-fe129c10Jr�6913_6� 2d2-a�    3d5�,7-870a0e6d75b� 692098321d46c6b9en454-8f8a-2abc09j9cf�20A/87_�L 1547�1H0d-8ace-a5767baf0b0b�L921004580_76f667f5-7K23['9�$7537a63424f�F152�2e86b2�V0�<s(Q(6953a7ded8db
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: � 5611b�"    F$3868_70796Kc5� 296-a9�, cffc: 7bj�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: @921229207_296dded>c�; 2f-b�$4a8da9b350b�6F321�J(e29-3bf�42�= 9-5c� 5611b�"    F$3868_70796Kc5� 296-a9�, cffc: 7bj�12�f01�2��5f7-b840P2 cdf5590d9bv258�8,_492c1ade-d66.cd5-bc0�Q 5f6f90dbej�5� 81_6�0� 1b9��8-1
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: 05857208_c750bl%89�079-a4_2 bd14f501fbt"6�fE,_2d9a864b-c0�?<04e-994e-5e56cdb�A^8�2�D49_7510d06b-e11�5�90-zPe18a778^z    F45�<$cdc655e-e2�) c4-9�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 87� j�05857208_c750bl%89�079-a4_2 bd14f501fbt"6�fE,_2d9a864b-c0�?<04e-994e-5e56cdb�A^8�2�D49_7510d06b-e11�5�90-zPe18a778^z    F45�<$cdc655e-e2�) c4-9�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F 7217$672a�Q7c'��# -4d3[C217b    F43087_d6dd8fb2-T P-3d7f-b81f-1dcd8a5f09b�    F430L    03db4fc-fec5-3�!b2w ded3119e7b#    F(5632_8f1132�6��285-b!�$5b33ba502fbFFP7172615168_373d3ff7-9�39az+ 35-7#daacb0bvF6977_afS c1-2N3c$8df8-eea�853^    F�_9089d2(216b-35ba-8�" 04ed793feb�F�H05_867d15c4-31�/c7c-bHb2cp 4HZ`)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: (e77e319ce49^J    F,5846_a1101faWS 8f-3fDa�Hf56�+ 18a2^�    F 7259�Occ1�T4| 1�747d4-55ab05e188b&F 7217$672a�Q7c'��# -4d3[C217b    F43087_d6dd8fb2-T P-3d7f-b81f-1dcd8a5f09b�    F430L    03db4fc-fec5-3�!b2w ded3119e7b#    F(5632_8f1132�6��285-b!�$5b33ba502fbFFP7172615168_373d3ff7-9�39az+ 35-7#daacb0bvF6977_afS c1-2N3c$8df8-eea�853^    F�_9089d2(216b-35ba-8�" 04ed793feb�F�H05_867d15c4-31�/c7c-bHb2cp 4HZ`F�Ej$1beb0b3-094e77-a1�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F�767876_b21db6dc-bf8d-3f6c-92e1-cd34c7339098^v420769' b1a0�%T.EDf0-8da8-aa4b1624dcb�0F*4_da5f4)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: F�H6_4ie7�� 9f-3Y8b435-b54c05c372b        F@1781_786669c1-056v%�,7f9-54�: f263bhF�767876_b21db6dc-bf8d-3f6c-92e1-cd34c7339098^v420769' b1a0�%T.EDf0-8da8-aa4b1624dcb�0F*4_da5f4
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �-E8_�,9ce0-W-39d0-b^5a22434ebcffe44cd8eb9�<5�[7(_547cec51-22KLc21-82b4-aada9f6ddab )
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 5� 3cR&�Q(7fc8fa9604bbx�-E8_�,9ce0-W-39d0-b^5a22434ebcffe44cd8eb9�<5�[7(_547cec51-22KLc21-82b4-aada9f6ddab
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �hG44�X5d64d6cI0bF9�;,36f44c9a-d59�V8d6-9e81-2051b49�.Av^F(99471_2849c��be�740-91IW 90847d127�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: fc�hG44�X5d64d6cI0bF9�;,36f44c9a-d59�V8d6-9e81-2051b49�.Av^F(99471_2849c��be�740-91IW 90847d127�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is:  9303385_767b2�/2e-�?� 485c1a1�2R� 29987831_�1f�:f� 37f�B5�)12g319�bF9/1dyC�<801)(f-bd80-b8d8� 8c�Z^F910J)$90267a6-ed, 80� $ad8e59a12c�VRF 3004dM,_f3f0eb06-f0p?83�F0e4-35d4892a9f^$bF 3508_f03e�� e�446-c5f992b9dc1� bFD4944_bc76f0e7-0b3d>]D5-ade9-d2881a631cd��VF@3959030_daf64c93-�L326�8�$ ae68aa3c4z+^F,61539_adbc4c'7��3�[6ec-5e1e�37j�/,3375_073250f�Pc�,H6a-aac7-d798fcb2a7d4V�43�0_f818ce5b-d9d�)8b45-5c90f92f65cj)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: ZF302��034438��24N704FF3411aScn� 9303385_767b2�/2e-�?� 485c1a1�2R� 29987831_�1f�:f� 37f�B5�)12g319�bF9/1dyC�<801)(f-bd80-b8d8� 8c�Z^F910J)$90267a6-ed, 80� $ad8e59a12c�VRF 3004dM,_f3f0eb06-f0p?83�F0e4-35d4892a9f^$bF 3508_f03e�� e�446-c5f992b9dc1� bFD4944_bc76f0e7-0b3d>]D5-ade9-d2881a631cd��VF@3959030_daf64c93-�L326�8�$ ae68aa3c4z+^F,61539_adbc4c'7��3�[6ec-5e1e�37j�/,3375_073250f�Pc�,H6a-aac7-d798fcb2a7d4V�43�0_f818ce5b-d9d�)8b45-5c90f92f65cj4)21_6b70dP552�� 25JLcd2cddd�b�47204_ed3f80dd-�)@3-b859-4bb5498e98�ZF4A8_d6e3bV;e�9d73-a7aH$afba19f75b�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F458,10a4a�9�Lf2b-a8be-97f6f0b599cb�F6077_eff�# b-e2>�D8a1e5-a7125bf83881^�T83906_1aba8565-72c2-350H�!(746ff8c56d2�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: bF9\!,cde62dce-c10,f063�99f237a0$^F<40720_6cf7b0a5-6=@3be�a5�    �bd89�NF 7848/%xK(d90d19-cdbd�><83e6-dff5559f9d9b�F458,10a4a�9�Lf2b-a8be-97f6f0b599cb�F6077_eff�# b-e2>�D8a1e5-a7125bf83881^�T83906_1aba8565-72c2-350H�!(746ff8c56d2�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is:      f-c3�C 3d0- (-1f2ef3daf9�$V�538_f1da0Ac1��9d7�4-841e4�Nb4j�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: U4fe8-94da-4f006�.5ab4�X 87986_818     f-c3�C 3d0- (-1f2ef3daf9�$V�538_f1da0Ac1��9d7�4-841e4�Nb4j� 5191jY beac�% 1d77�9Dd-b1cb-1dbeb426f78>Z� U$99_1cd592b�+6Z-70@f!5Av 1754j�\5243339_c8c6f91c-5816-35�f2a-53t! 2d3e)b�60�3c4@)a$�V 88c0�?5509245f��W03�) 1039 -9f�;�S88470-aa6b46a521,R��X$5143_aad07oT81j6La76-b6d5-e287a2ab3aef�F7�0bvLed7-0f$�[89(-136c7a97d6V���2�F` 45a1)0J�daA� 75bbb��WX56086_33eb9075-4fab-313�(4e-��c67272bb�    F7479_39 09-0� 36�N3�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: 40)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 95dd67v^�    <792404589_1d7d57�#3a7,4f07-412c67f858n<Z40K_44082�2e4�`DW�/ 16d9c6e73:^F$10453_518c�T-1de' 3fa-d
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: (f5ab6633fbcb�
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F@60800_c71931ef-ab�[cV276�a4�/57)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: 57n<�74b63d-f39a-3b65�@(2-8aeadabd6j�F9455_�*b4�%1e�6e�gb-�fde0fjF@60800_c71931ef-ab�[cV276�a4�/57
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: �V<0053_048494c7-98�E369-a206�� 5c73f4e7c^�)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: N�V<0053_048494c7-98�E369-a206�� 5c73f4e7c^�F30Zd6bf724�/�e99-9�1$88a62bac3dfF 5774f
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: $69410272_c+Y(2c9-7822-33�28� db6648722b�F<1619_a55f87bd-4a)
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: b54f3-1c�`e6fFF9-96cde�c7b��V21490Z63pC-3�!b?(105665663c9b�F�C�876ce�� 6-39e 2a-ed83cb0%f FT5804_9f3d0bb8-f258-3c8�S 87b9�HcfJ@869408446_023e956��1�41�8-9]#9 E�0R�$69410272_c+Y(2c9-7822-33�28� db6648722b�F<1619_a55f87bd-4a
10:02:40.943 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F461021_0784d9c0y a-32>a6b-2C14218D^�636:4 1fa7f91-b�e$3d0c-bbe8-�2292e29�bF$5070_4f7b381awe38�'5b7-16�45b73f)
10:02:40.944 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: F461021_0784d9c0y a-32>a6b-2C14218D^�636:4 1fa7f91-b�e$3d0c-bbe8-�2292e29�bF$5070_4f7b381awe38�'5b7-16�45b73f943042"3>A4d-54d)6a9�,6-69a22d95fen<R�F 6609_8f70` -95�cf
10:02:40.944 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F,8438_bc3d5b355#3-a07�de555ce5DfN� 9528;�41aea3��258b5e-29f41d7ad6cb�F<8476_d737befe-768762-bb�� 388d46b17�>^�70�!�e9rb4~TG9f9-7d)
10:02:40.944 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: bf4e-a�246f993f�F,8438_bc3d5b355#3-a07�de555ce5DfN� 9528;�41aea3��258b5e-29f41d7ad6cb�F<8476_d737befe-768762-bb�� 388d46b17�>^�70�!�e9rb4~TG9f9-7d
10:02:40.944 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: F22fSc�08cee-fe2f-36c2-aw(4105e5744f3bf)
10:02:40.944 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: >2eFb�PU$44969_2aac.-c5."�235-dsjd�.h3V�(3647281_536�4-166D b4-9�h"bf10a3� bF9�3 623bdd62-~&!��&eb�ef�d44b�    8953719780_2934e5J[P31e0-a145-6bb0d2e7616b4F22fSc�08cee-fe2f-36c2-aw(4105e5744f3bf
10:02:40.944 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: Error converting column: 1 TO BIGINT (Data is: 8�.2_0e4bd1f$3�,493-32066db9vPr� 4533)
10:02:40.944 AM    INFO    runtime-state.cc:228    
Error from query 9446af1516dfafd2:4b903485559cd691: file: hdfs://nameservice1/user/root/test/tracking/part-r-1.parquet
record: F3�R07c0af6�e�`$01-a063-f4�#44247d^J9PU0437_ak576-e7l\8bd-apSb6e�f30&9Z^8�.2_0e4bd1f$3�,493-32066db9vPr� 4533

The parquet file was generated from Spark (Spark 1.1.0 via CDH5.2.1 Parcels) with the method `saveAsParquetFile`. From my understanding, this might be an issue with UTF-8 not being readable by Impala. In that case, do you know any way to be able to read a saveAsParquetFile from Spark in Impala ?

Another new issue has arisen too since CDH5.2.1, before in CDH5.2.0, I could read at least the data in Hive. Now, I can't read it, I got something like this :

 

0    PAR1��    NULL    NULL    NULL
1    ��,�Bimpression-hash_1417172009391_4ce37995-ec69-3165-82a6-28b8921a9e8bBa49381ca2f6c691_1415618888645_47fd7d2b-0eec-3527-ab62-6f009307d1c6���L�    NULL    �9295510_560879bc-6c7e-37a0-8439-5b000ad1a3fbBj    h98316_e8d89936-608b-3f59-81A0(3def0143641j�T300723_4b5d8199-70e0-3A�@a6c9-dde0f6c37f8ebF�29993017_f6e888b7-c0b2-3c57-8b10-74daa6a840f1rFD4341_094e3dbd-104d!H2-8c55-eb646e4064cdrF<5506_fe2b6aaf-df
2    f9-dc2��H74-992e-69d205fa168bH    NULL    NULL    NULL
3    271b1��\bc-3ad9-842c-76caf666b95j^    NULL    L5195766_e571ed5f-16daHcf-b56 f31b02492z�86925_c7ba3e53-2rT37b4-80ce-ff04d3e962c0j��232566_641a409f-bb29-3f21-abd8-5699890c!znF�42102_fcfb6ea1-fb52-3daa-bb92-ab9ad6d8842b    NULL
4    785244��0aeb0409c-401c    NULL    �473�    NULL
5     5aa241-a6a    NULL    NULL    NULL
6    <b833-492dd3263eaf�    NULL    NULL    NULL
7    'afd749efT92360697_771900f6-52a8�bd��,0-6e1dbb8451f|F�1960_516f47c9-9c61-3477-9d38-c6c9247adeecf^    NULL    P2403302_ad21c446-8495    �3-,-751691aec2dj�H2406372_6857350b-86�    @877-b4ad-65a401e4
8    2b�2Df9-8ed7-033844f1d1fP801062854_72a20855-8b%cD4b-98ba-dc00cf7020f|F<4153_ea25f735-51A�P0ac-8cc6-0f7e73884645^�F5497_ff�    9f-9fe5�Dd-bd71-4b83ad4c0d6bL    F@6967_28e165fd-445�aa!��j c0996f6b2b^    NULL    F499465_ef081a05��Xd-32b9-ad44-f5b3b5cea02b�80110�@_3b36a42e-aa8a-3ea�ccb!^�    NULL
9    76c3b�    NULL    NULL    NULL
10    D3-8415-5d9bc405f1bb�P868831418_f5280ec1-11zPc84-880d-1e37794591b4b
2 ACCEPTED SOLUTIONS

avatar
Cloudera Employee

It looks to me like your Parquet table was created with the wrong table format, possibly text. In the Impala shell, could you run "describe formatted <table>" and post the SerDe Library, InputFormat, and OutputFormat?

View solution in original post

avatar
Explorer

Hello,

 

Ok, it's working now indeed it was in text format. I use the command "describe formatted <table>" & "show create <table>" as suggested.

 

To create the Impala table I use the following query :

 

CREATE EXTERNAL TABLE spark_parquet
LIKE PARQUET '/user/root/test/_metadata'
LOCATION '/user/root/test'

I thought the "LIKE PARQUET" part was enough to detect we want it to store as Parquet format. But it seems not enough, I've just changed it to :

 

CREATE EXTERNAL TABLE spark_parquet
LIKE PARQUET '/user/root/test/_metadata'
STORED AS PARQUET
LOCATION '/user/root/test'

 And everything works now. Thank you !

 

 

View solution in original post

3 REPLIES 3

avatar
Cloudera Employee

It looks to me like your Parquet table was created with the wrong table format, possibly text. In the Impala shell, could you run "describe formatted <table>" and post the SerDe Library, InputFormat, and OutputFormat?

avatar
Explorer

Hello,

 

Ok, it's working now indeed it was in text format. I use the command "describe formatted <table>" & "show create <table>" as suggested.

 

To create the Impala table I use the following query :

 

CREATE EXTERNAL TABLE spark_parquet
LIKE PARQUET '/user/root/test/_metadata'
LOCATION '/user/root/test'

I thought the "LIKE PARQUET" part was enough to detect we want it to store as Parquet format. But it seems not enough, I've just changed it to :

 

CREATE EXTERNAL TABLE spark_parquet
LIKE PARQUET '/user/root/test/_metadata'
STORED AS PARQUET
LOCATION '/user/root/test'

 And everything works now. Thank you !

 

 

avatar
Rising Star

fixed it for me.

 

strange that Impala does not automatically chooses Parquet format when creating an external table based on a Parquet file.