Cloudera Community

Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Solved Go to solution

Cannot read Parquet format generated by Spark

avatar
author-rank nphung
Explorer

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!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-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,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�(1b6844187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]#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_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
14,965 Views
0 Kudos
2 ACCEPTED SOLUTIONS

avatar
Skye author-rank
Cloudera Employee

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?

View solution in original post

14,958 Views

avatar
author-rank nphung
Explorer

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 !

 

 

View solution in original post

14,940 Views
3 REPLIES 3

avatar
Skye author-rank
Cloudera Employee

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?

14,959 Views

avatar
author-rank nphung
Explorer

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 !

 

 

14,941 Views

avatar
author-rank crcerror
Rising Star

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.

10,969 Views
0 Kudos
Announcements
What's New @ Cloudera
[RELEASED] Cloudera Streams Messaging - Kubernetes Operator ...
What's New @ Cloudera
[RELEASED] Cloudera Streaming Analytics 1.14 for Cloudera Pu...
What's New @ Cloudera
Cloudera Data Engineering 1.23: Access Spark from Your Favor...
What's New @ Cloudera
HBase REST server scaling support is Generally Available
What's New @ Cloudera
New CLI option in the update-database command
View More Announcements