Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created on 12-10-2014 05:23 AM - edited 09-16-2022 02:14 AM
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-2rT37b4-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!F75N71bb4de-��-�%@-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-1998dde117djv5204_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-1998dde117djv5204_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-da38856n^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,009a-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,009a-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�557d115^� 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^jF4294�� 03be30-1f�,<a8f-98e4-5466535�^�F<51976_f1515fb3-e~8T4�!(4b4737407c5j0 754695_b3�-4e�F81af���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$6q53b�$ 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�97237467daa770e-3c45>b-4522796j�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: a4593�;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-514041c0e2fNF,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-514041c0e2fNF,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�($a83f418984bP842022004_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�(1b6844187cdcbf�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�$cae450db71b8)
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�$cae450db71b8�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 F93vHd2734f0!^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_�L1547�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: F7217$672a�Q7c'��#-4d3[C217b F43087_d6dd8fb2-TP-3d7f-b81f-1dcd8a5f09b� F430L 03db4fc-fec5-3�!b2w ded3119e7b# F(5632_8f1132�6��285-b!�$5b33ba502fbFFP7172615168_373d3ff7-9�39az+35-7#daacb0bvF6977_afSc1-2N3c$8df8-eea�853^ F�_9089d2(216b-35ba-8�" 04ed793feb�F�H05_867d15c4-31�/c7c-bHb2cp4HZ`)
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_a1101faWS8f-3fDa�Hf56�+18a2^� F7259�Occ1�T4|1�747d4-55ab05e188b&F7217$672a�Q7c'��#-4d3[C217b F43087_d6dd8fb2-TP-3d7f-b81f-1dcd8a5f09b� F430L 03db4fc-fec5-3�!b2w ded3119e7b# F(5632_8f1132�6��285-b!�$5b33ba502fbFFP7172615168_373d3ff7-9�39az+35-7#daacb0bvF6977_afSc1-2N3c$8df8-eea�853^ F�_9089d2(216b-35ba-8�" 04ed793feb�F�H05_867d15c4-31�/c7c-bHb2cp4HZ`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�VRF3004dM,_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�VRF3004dM,_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�NF7848/%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�C3d0-(-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�C3d0-(-1f2ef3daf9�$V�538_f1da0Ac1��9d7�4-841e4�Nb4j�5191jYbeac�%1d77�9Dd-b1cb-1dbeb426f78>Z�U$99_1cd592b�+6Z-70@f!5Av1754j�\5243339_c8c6f91c-5816-35�f2a-53t!2d3e)b�60�3c4@)a$�V88c0�?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$88a62bac3dfF5774f
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%fFT5804_9f3d0bb8-f258-3c8�S87b9�HcfJ@869408446_023e956��1�41�8-9]#9E�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_0784d9c0ya-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_0784d9c0ya-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
Created 12-10-2014 10:14 AM
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?
Created 12-11-2014 12:04 AM
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 !
Created 12-10-2014 10:14 AM
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?
Created 12-11-2014 12:04 AM
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 !
Created 01-22-2021 02:22 AM
fixed it for me.
strange that Impala does not automatically chooses Parquet format when creating an external table based on a Parquet file.