[ATLAS-4524] HiveMetaStoreBridge.registerTable() fails when importing hive tables with large columns - ASF JIRA

Attach files

Attach Screenshot

Add vote

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Open
Priority: Major
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: atlas-core
Labels:
None

Description

Steps to repro:

Disable hive hook
Create a table with 1000 columns
Import the table using hive-import command

2022-01-06 13:51:52,329 ERROR - [main:] ~ Import failed for hive_table hive_table_tmwos (HiveMetaStoreBridge:503)
org.apache.atlas.hook.AtlasHookException: HiveMetaStoreBridge.registerTable() failed.
    at org.apache.atlas.hive.bridge.HiveMetaStoreBridge.registerTable(HiveMetaStoreBridge.java:559)
    at org.apache.atlas.hive.bridge.HiveMetaStoreBridge.importTable(HiveMetaStoreBridge.java:448)
    at org.apache.atlas.hive.bridge.HiveMetaStoreBridge.importTables(HiveMetaStoreBridge.java:426)
    at org.apache.atlas.hive.bridge.HiveMetaStoreBridge.importDatabases(HiveMetaStoreBridge.java:395)
    at org.apache.atlas.hive.bridge.HiveMetaStoreBridge.importDataDirectlyToAtlas(HiveMetaStoreBridge.java:352)
    at org.apache.atlas.hive.bridge.HiveMetaStoreBridge.main(HiveMetaStoreBridge.java:186)
Caused by: com.sun.jersey.api.client.ClientHandlerException: java.net.SocketTimeoutException: Read timed out
    at com.sun.jersey.client.urlconnection.URLConnectionClientHandler.handle(URLConnectionClientHandler.java:155)
    at com.sun.jersey.api.client.Client.handle(Client.java:652)
    at com.sun.jersey.api.client.WebResource.handle(WebResource.java:682)
    at com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)
    at com.sun.jersey.api.client.WebResource$Builder.method(WebResource.java:634)
    at org.apache.atlas.AtlasBaseClient.callAPIWithResource(AtlasBaseClient.java:402)
    at org.apache.atlas.AtlasBaseClient.callAPIWithResource(AtlasBaseClient.java:366)
    at org.apache.atlas.AtlasBaseClient.callAPIWithResource(AtlasBaseClient.java:352)
    at org.apache.atlas.AtlasBaseClient.callAPI(AtlasBaseClient.java:228)
    at org.apache.atlas.AtlasClientV2.createEntity(AtlasClientV2.java:431)
    at org.apache.atlas.hive.bridge.HiveMetaStoreBridge.registerInstance(HiveMetaStoreBridge.java:575)
    at org.apache.atlas.hive.bridge.HiveMetaStoreBridge.registerTable(HiveMetaStoreBridge.java:548)
    ... 5 more
Caused by: java.net.SocketTimeoutException: Read timed out
    at java.base/java.net.SocketInputStream.socketRead0(Native Method)
    at java.base/java.net.SocketInputStream.socketRead(SocketInputStream.java:115)
    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:168)
    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140)
    at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:448)
    at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:68)
    at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1104)
    at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:823)
    at java.base/java.io.BufferedInputStream.fill(BufferedInputStream.java:252)
    at java.base/java.io.BufferedInputStream.read1(BufferedInputStream.java:292)
    at java.base/java.io.BufferedInputStream.read(BufferedInputStream.java:351)
    at java.base/sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:746)
    at java.base/sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:689)
    at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1604)
    at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1509)
    at java.base/java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:527)
    at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:329)
    at com.sun.jersey.client.urlconnection.URLConnectionClientHandler._invoke(URLConnectionClientHandler.java:253)
    at com.sun.jersey.client.urlconnection.URLConnectionClientHandler.handle(URLConnectionClientHandler.java:153)
    ... 16 more

Sample query to create a table with 1000 columns :

 "create database hive_db_vxofz; use hive_db_vxofz; create table hive_table_tmwos(hive_column_bhngv_1 bigint, hive_column_bhngv_2 boolean, hive_column_bhngv_3 varchar(25), hive_column_bhngv_4 smallint, hive_column_bhngv_5 bigint, hive_column_bhngv_6 int, hive_column_bhngv_7 int, hive_column_bhngv_8 timestamp, hive_column_bhngv_9 float, hive_column_bhngv_10 float, hive_column_bhngv_11 float, hive_column_bhngv_12 boolean, hive_column_bhngv_13 timestamp, hive_column_bhngv_14 boolean, hive_column_bhngv_15 bigint, hive_column_bhngv_16 decimal(38,18), hive_column_bhngv_17 date, hive_column_bhngv_18 smallint, hive_column_bhngv_19 string, hive_column_bhngv_20 char(25), hive_column_bhngv_21 int, hive_column_bhngv_22 varchar(25), hive_column_bhngv_23 boolean, hive_column_bhngv_24 decimal(38,18), hive_column_bhngv_25 smallint, hive_column_bhngv_26 timestamp, hive_column_bhngv_27 char(25), hive_column_bhngv_28 varchar(25), hive_column_bhngv_29 string, hive_column_bhngv_30 char(25), hive_column_bhngv_31 boolean, hive_column_bhngv_32 date, hive_column_bhngv_33 varchar(25), hive_column_bhngv_34 int, hive_column_bhngv_35 decimal(38,18), hive_column_bhngv_36 boolean, hive_column_bhngv_37 boolean, hive_column_bhngv_38 decimal(38,18), hive_column_bhngv_39 date, hive_column_bhngv_40 string, hive_column_bhngv_41 boolean, hive_column_bhngv_42 timestamp, hive_column_bhngv_43 string, hive_column_bhngv_44 date, hive_column_bhngv_45 decimal(38,18), hive_column_bhngv_46 decimal(38,18), hive_column_bhngv_47 varchar(25), hive_column_bhngv_48 timestamp, hive_column_bhngv_49 double, hive_column_bhngv_50 varchar(25), hive_column_bhngv_51 char(25), hive_column_bhngv_52 varchar(25), hive_column_bhngv_53 smallint, hive_column_bhngv_54 string, hive_column_bhngv_55 boolean, hive_column_bhngv_56 varchar(25), hive_column_bhngv_57 date, hive_column_bhngv_58 boolean, hive_column_bhngv_59 float, hive_column_bhngv_60 smallint, hive_column_bhngv_61 bigint, hive_column_bhngv_62 boolean, hive_column_bhngv_63 string, hive_column_bhngv_64 timestamp, hive_column_bhngv_65 int, hive_column_bhngv_66 int, hive_column_bhngv_67 float, hive_column_bhngv_68 bigint, hive_column_bhngv_69 double, hive_column_bhngv_70 char(25), hive_column_bhngv_71 string, hive_column_bhngv_72 double, hive_column_bhngv_73 smallint, hive_column_bhngv_74 varchar(25), hive_column_bhngv_75 boolean, hive_column_bhngv_76 char(25), hive_column_bhngv_77 double, hive_column_bhngv_78 decimal(38,18), hive_column_bhngv_79 float, hive_column_bhngv_80 smallint, hive_column_bhngv_81 int, hive_column_bhngv_82 int, hive_column_bhngv_83 decimal(38,18), hive_column_bhngv_84 bigint, hive_column_bhngv_85 int, hive_column_bhngv_86 int, hive_column_bhngv_87 decimal(38,18), hive_column_bhngv_88 char(25), hive_column_bhngv_89 int, hive_column_bhngv_90 varchar(25), hive_column_bhngv_91 timestamp, hive_column_bhngv_92 smallint, hive_column_bhngv_93 bigint, hive_column_bhngv_94 smallint, hive_column_bhngv_95 boolean, hive_column_bhngv_96 smallint, hive_column_bhngv_97 timestamp, hive_column_bhngv_98 int, hive_column_bhngv_99 smallint, hive_column_bhngv_100 double, hive_column_bhngv_101 decimal(38,18), hive_column_bhngv_102 string, hive_column_bhngv_103 char(25), hive_column_bhngv_104 int, hive_column_bhngv_105 double, hive_column_bhngv_106 varchar(25), hive_column_bhngv_107 string, hive_column_bhngv_108 varchar(25), hive_column_bhngv_109 decimal(38,18), hive_column_bhngv_110 decimal(38,18), hive_column_bhngv_111 string, hive_column_bhngv_112 bigint, hive_column_bhngv_113 timestamp, hive_column_bhngv_114 float, hive_column_bhngv_115 float, hive_column_bhngv_116 float, hive_column_bhngv_117 timestamp, hive_column_bhngv_118 decimal(38,18), hive_column_bhngv_119 varchar(25), hive_column_bhngv_120 timestamp, hive_column_bhngv_121 boolean, hive_column_bhngv_122 date, hive_column_bhngv_123 timestamp, hive_column_bhngv_124 varchar(25), hive_column_bhngv_125 varchar(25), hive_column_bhngv_126 string, hive_column_bhngv_127 decimal(38,18), hive_column_bhngv_128 double, hive_column_bhngv_129 char(25), hive_column_bhngv_130 smallint, hive_column_bhngv_131 boolean, hive_column_bhngv_132 float, hive_column_bhngv_133 smallint, hive_column_bhngv_134 float, hive_column_bhngv_135 string, hive_column_bhngv_136 timestamp, hive_column_bhngv_137 bigint, hive_column_bhngv_138 string, hive_column_bhngv_139 timestamp, hive_column_bhngv_140 int, hive_column_bhngv_141 smallint, hive_column_bhngv_142 boolean, hive_column_bhngv_143 boolean, hive_column_bhngv_144 char(25), hive_column_bhngv_145 timestamp, hive_column_bhngv_146 int, hive_column_bhngv_147 timestamp, hive_column_bhngv_148 date, hive_column_bhngv_149 string, hive_column_bhngv_150 bigint, hive_column_bhngv_151 boolean, hive_column_bhngv_152 bigint, hive_column_bhngv_153 timestamp, hive_column_bhngv_154 date, hive_column_bhngv_155 string, hive_column_bhngv_156 varchar(25), hive_column_bhngv_157 char(25), hive_column_bhngv_158 bigint, hive_column_bhngv_159 timestamp, hive_column_bhngv_160 boolean, hive_column_bhngv_161 timestamp, hive_column_bhngv_162 timestamp, hive_column_bhngv_163 decimal(38,18), hive_column_bhngv_164 double, hive_column_bhngv_165 float, hive_column_bhngv_166 timestamp, hive_column_bhngv_167 smallint, hive_column_bhngv_168 int, hive_column_bhngv_169 string, hive_column_bhngv_170 timestamp, hive_column_bhngv_171 char(25), hive_column_bhngv_172 char(25), hive_column_bhngv_173 boolean, hive_column_bhngv_174 double, hive_column_bhngv_175 timestamp, hive_column_bhngv_176 int, hive_column_bhngv_177 string, hive_column_bhngv_178 timestamp, hive_column_bhngv_179 char(25), hive_column_bhngv_180 int, hive_column_bhngv_181 char(25), hive_column_bhngv_182 int, hive_column_bhngv_183 double, hive_column_bhngv_184 boolean, hive_column_bhngv_185 bigint, hive_column_bhngv_186 float, hive_column_bhngv_187 double, hive_column_bhngv_188 smallint, hive_column_bhngv_189 varchar(25), hive_column_bhngv_190 varchar(25), hive_column_bhngv_191 float, hive_column_bhngv_192 smallint, hive_column_bhngv_193 char(25), hive_column_bhngv_194 date, hive_column_bhngv_195 smallint, hive_column_bhngv_196 varchar(25), hive_column_bhngv_197 timestamp, hive_column_bhngv_198 string, hive_column_bhngv_199 double, hive_column_bhngv_200 float, hive_column_bhngv_201 decimal(38,18), hive_column_bhngv_202 int, hive_column_bhngv_203 char(25), hive_column_bhngv_204 timestamp, hive_column_bhngv_205 boolean, hive_column_bhngv_206 int, hive_column_bhngv_207 char(25), hive_column_bhngv_208 bigint, hive_column_bhngv_209 smallint, hive_column_bhngv_210 decimal(38,18), hive_column_bhngv_211 char(25), hive_column_bhngv_212 int, hive_column_bhngv_213 varchar(25), hive_column_bhngv_214 float, hive_column_bhngv_215 float, hive_column_bhngv_216 char(25), hive_column_bhngv_217 double, hive_column_bhngv_218 timestamp, hive_column_bhngv_219 bigint, hive_column_bhngv_220 bigint, hive_column_bhngv_221 smallint, hive_column_bhngv_222 char(25), hive_column_bhngv_223 string, hive_column_bhngv_224 timestamp, hive_column_bhngv_225 date, hive_column_bhngv_226 bigint, hive_column_bhngv_227 double, hive_column_bhngv_228 string, hive_column_bhngv_229 date, hive_column_bhngv_230 string, hive_column_bhngv_231 decimal(38,18), hive_column_bhngv_232 decimal(38,18), hive_column_bhngv_233 date, hive_column_bhngv_234 varchar(25), hive_column_bhngv_235 int, hive_column_bhngv_236 char(25), hive_column_bhngv_237 double, hive_column_bhngv_238 smallint, hive_column_bhngv_239 boolean, hive_column_bhngv_240 timestamp, hive_column_bhngv_241 char(25), hive_column_bhngv_242 decimal(38,18), hive_column_bhngv_243 float, hive_column_bhngv_244 boolean, hive_column_bhngv_245 float, hive_column_bhngv_246 varchar(25), hive_column_bhngv_247 boolean, hive_column_bhngv_248 int, hive_column_bhngv_249 string, hive_column_bhngv_250 smallint, hive_column_bhngv_251 char(25), hive_column_bhngv_252 decimal(38,18), hive_column_bhngv_253 decimal(38,18), hive_column_bhngv_254 double, hive_column_bhngv_255 decimal(38,18), hive_column_bhngv_256 int, hive_column_bhngv_257 varchar(25), hive_column_bhngv_258 char(25), hive_column_bhngv_259 string, hive_column_bhngv_260 date, hive_column_bhngv_261 float, hive_column_bhngv_262 float, hive_column_bhngv_263 float, hive_column_bhngv_264 char(25), hive_column_bhngv_265 timestamp, hive_column_bhngv_266 date, hive_column_bhngv_267 int, hive_column_bhngv_268 double, hive_column_bhngv_269 float, hive_column_bhngv_270 timestamp, hive_column_bhngv_271 string, hive_column_bhngv_272 double, hive_column_bhngv_273 char(25), hive_column_bhngv_274 string, hive_column_bhngv_275 string, hive_column_bhngv_276 timestamp, hive_column_bhngv_277 smallint, hive_column_bhngv_278 char(25), hive_column_bhngv_279 char(25), hive_column_bhngv_280 boolean, hive_column_bhngv_281 int, hive_column_bhngv_282 timestamp, hive_column_bhngv_283 decimal(38,18), hive_column_bhngv_284 string, hive_column_bhngv_285 string, hive_column_bhngv_286 char(25), hive_column_bhngv_287 bigint, hive_column_bhngv_288 decimal(38,18), hive_column_bhngv_289 decimal(38,18), hive_column_bhngv_290 float, hive_column_bhngv_291 int, hive_column_bhngv_292 string, hive_column_bhngv_293 smallint, hive_column_bhngv_294 date, hive_column_bhngv_295 int, hive_column_bhngv_296 timestamp, hive_column_bhngv_297 int, hive_column_bhngv_298 double, hive_column_bhngv_299 date, hive_column_bhngv_300 boolean, hive_column_bhngv_301 smallint, hive_column_bhngv_302 bigint, hive_column_bhngv_303 date, hive_column_bhngv_304 varchar(25), hive_column_bhngv_305 bigint, hive_column_bhngv_306 string, hive_column_bhngv_307 float, hive_column_bhngv_308 decimal(38,18), hive_column_bhngv_309 decimal(38,18), hive_column_bhngv_310 varchar(25), hive_column_bhngv_311 double, hive_column_bhngv_312 smallint, hive_column_bhngv_313 char(25), hive_column_bhngv_314 bigint, hive_column_bhngv_315 smallint, hive_column_bhngv_316 char(25), hive_column_bhngv_317 date, hive_column_bhngv_318 date, hive_column_bhngv_319 decimal(38,18), hive_column_bhngv_320 int, hive_column_bhngv_321 double, hive_column_bhngv_322 smallint, hive_column_bhngv_323 timestamp, hive_column_bhngv_324 decimal(38,18), hive_column_bhngv_325 smallint, hive_column_bhngv_326 bigint, hive_column_bhngv_327 double, hive_column_bhngv_328 char(25), hive_column_bhngv_329 date, hive_column_bhngv_330 int, hive_column_bhngv_331 float, hive_column_bhngv_332 float, hive_column_bhngv_333 float, hive_column_bhngv_334 string, hive_column_bhngv_335 char(25), hive_column_bhngv_336 decimal(38,18), hive_column_bhngv_337 date, hive_column_bhngv_338 int, hive_column_bhngv_339 varchar(25), hive_column_bhngv_340 timestamp, hive_column_bhngv_341 string, hive_column_bhngv_342 float, hive_column_bhngv_343 double, hive_column_bhngv_344 bigint, hive_column_bhngv_345 timestamp, hive_column_bhngv_346 bigint, hive_column_bhngv_347 timestamp, hive_column_bhngv_348 smallint, hive_column_bhngv_349 string, hive_column_bhngv_350 bigint, hive_column_bhngv_351 smallint, hive_column_bhngv_352 smallint, hive_column_bhngv_353 date, hive_column_bhngv_354 string, hive_column_bhngv_355 string, hive_column_bhngv_356 float, hive_column_bhngv_357 float, hive_column_bhngv_358 timestamp, hive_column_bhngv_359 date, hive_column_bhngv_360 float, hive_column_bhngv_361 decimal(38,18), hive_column_bhngv_362 double, hive_column_bhngv_363 timestamp, hive_column_bhngv_364 smallint, hive_column_bhngv_365 boolean, hive_column_bhngv_366 string, hive_column_bhngv_367 double, hive_column_bhngv_368 int, hive_column_bhngv_369 string, hive_column_bhngv_370 date, hive_column_bhngv_371 timestamp, hive_column_bhngv_372 string, hive_column_bhngv_373 double, hive_column_bhngv_374 boolean, hive_column_bhngv_375 int, hive_column_bhngv_376 double, hive_column_bhngv_377 char(25), hive_column_bhngv_378 smallint, hive_column_bhngv_379 char(25), hive_column_bhngv_380 smallint, hive_column_bhngv_381 char(25), hive_column_bhngv_382 bigint, hive_column_bhngv_383 varchar(25), hive_column_bhngv_384 double, hive_column_bhngv_385 decimal(38,18), hive_column_bhngv_386 float, hive_column_bhngv_387 smallint, hive_column_bhngv_388 char(25), hive_column_bhngv_389 char(25), hive_column_bhngv_390 string, hive_column_bhngv_391 boolean, hive_column_bhngv_392 timestamp, hive_column_bhngv_393 char(25), hive_column_bhngv_394 varchar(25), hive_column_bhngv_395 decimal(38,18), hive_column_bhngv_396 char(25), hive_column_bhngv_397 varchar(25), hive_column_bhngv_398 date, hive_column_bhngv_399 timestamp, hive_column_bhngv_400 double, hive_column_bhngv_401 varchar(25), hive_column_bhngv_402 string, hive_column_bhngv_403 string, hive_column_bhngv_404 char(25), hive_column_bhngv_405 string, hive_column_bhngv_406 bigint, hive_column_bhngv_407 string, hive_column_bhngv_408 int, hive_column_bhngv_409 int, hive_column_bhngv_410 double, hive_column_bhngv_411 char(25), hive_column_bhngv_412 bigint, hive_column_bhngv_413 float, hive_column_bhngv_414 float, hive_column_bhngv_415 boolean, hive_column_bhngv_416 smallint, hive_column_bhngv_417 double, hive_column_bhngv_418 varchar(25), hive_column_bhngv_419 char(25), hive_column_bhngv_420 double, hive_column_bhngv_421 string, hive_column_bhngv_422 bigint, hive_column_bhngv_423 smallint, hive_column_bhngv_424 char(25), hive_column_bhngv_425 smallint, hive_column_bhngv_426 bigint, hive_column_bhngv_427 bigint, hive_column_bhngv_428 float, hive_column_bhngv_429 decimal(38,18), hive_column_bhngv_430 string, hive_column_bhngv_431 float, hive_column_bhngv_432 timestamp, hive_column_bhngv_433 smallint, hive_column_bhngv_434 varchar(25), hive_column_bhngv_435 timestamp, hive_column_bhngv_436 smallint, hive_column_bhngv_437 float, hive_column_bhngv_438 smallint, hive_column_bhngv_439 float, hive_column_bhngv_440 char(25), hive_column_bhngv_441 date, hive_column_bhngv_442 double, hive_column_bhngv_443 bigint, hive_column_bhngv_444 smallint, hive_column_bhngv_445 char(25), hive_column_bhngv_446 bigint, hive_column_bhngv_447 int, hive_column_bhngv_448 float, hive_column_bhngv_449 char(25), hive_column_bhngv_450 string, hive_column_bhngv_451 timestamp, hive_column_bhngv_452 decimal(38,18), hive_column_bhngv_453 boolean, hive_column_bhngv_454 boolean, hive_column_bhngv_455 char(25), hive_column_bhngv_456 int, hive_column_bhngv_457 int, hive_column_bhngv_458 timestamp, hive_column_bhngv_459 bigint, hive_column_bhngv_460 date, hive_column_bhngv_461 double, hive_column_bhngv_462 string, hive_column_bhngv_463 float, hive_column_bhngv_464 smallint, hive_column_bhngv_465 bigint, hive_column_bhngv_466 float, hive_column_bhngv_467 float, hive_column_bhngv_468 varchar(25), hive_column_bhngv_469 timestamp, hive_column_bhngv_470 double, hive_column_bhngv_471 double, hive_column_bhngv_472 varchar(25), hive_column_bhngv_473 varchar(25), hive_column_bhngv_474 string, hive_column_bhngv_475 string, hive_column_bhngv_476 string, hive_column_bhngv_477 timestamp, hive_column_bhngv_478 boolean, hive_column_bhngv_479 date, hive_column_bhngv_480 bigint, hive_column_bhngv_481 float, hive_column_bhngv_482 smallint, hive_column_bhngv_483 bigint, hive_column_bhngv_484 varchar(25), hive_column_bhngv_485 timestamp, hive_column_bhngv_486 int, hive_column_bhngv_487 date, hive_column_bhngv_488 char(25), hive_column_bhngv_489 char(25), hive_column_bhngv_490 decimal(38,18), hive_column_bhngv_491 varchar(25), hive_column_bhngv_492 double, hive_column_bhngv_493 decimal(38,18), hive_column_bhngv_494 smallint, hive_column_bhngv_495 smallint, hive_column_bhngv_496 varchar(25), hive_column_bhngv_497 date, hive_column_bhngv_498 char(25), hive_column_bhngv_499 double, hive_column_bhngv_500 int, hive_column_bhngv_501 timestamp, hive_column_bhngv_502 int, hive_column_bhngv_503 varchar(25), hive_column_bhngv_504 varchar(25), hive_column_bhngv_505 char(25), hive_column_bhngv_506 string, hive_column_bhngv_507 varchar(25), hive_column_bhngv_508 string, hive_column_bhngv_509 smallint, hive_column_bhngv_510 decimal(38,18), hive_column_bhngv_511 float, hive_column_bhngv_512 int, hive_column_bhngv_513 string, hive_column_bhngv_514 boolean, hive_column_bhngv_515 varchar(25), hive_column_bhngv_516 boolean, hive_column_bhngv_517 int, hive_column_bhngv_518 smallint, hive_column_bhngv_519 double, hive_column_bhngv_520 boolean, hive_column_bhngv_521 decimal(38,18), hive_column_bhngv_522 boolean, hive_column_bhngv_523 float, hive_column_bhngv_524 varchar(25), hive_column_bhngv_525 double, hive_column_bhngv_526 varchar(25), hive_column_bhngv_527 boolean, hive_column_bhngv_528 date, hive_column_bhngv_529 smallint, hive_column_bhngv_530 decimal(38,18), hive_column_bhngv_531 varchar(25), hive_column_bhngv_532 timestamp, hive_column_bhngv_533 char(25), hive_column_bhngv_534 date, hive_column_bhngv_535 float, hive_column_bhngv_536 smallint, hive_column_bhngv_537 float, hive_column_bhngv_538 bigint, hive_column_bhngv_539 date, hive_column_bhngv_540 date, hive_column_bhngv_541 boolean, hive_column_bhngv_542 timestamp, hive_column_bhngv_543 timestamp, hive_column_bhngv_544 boolean, hive_column_bhngv_545 double, hive_column_bhngv_546 smallint, hive_column_bhngv_547 float, hive_column_bhngv_548 timestamp, hive_column_bhngv_549 char(25), hive_column_bhngv_550 bigint, hive_column_bhngv_551 int, hive_column_bhngv_552 double, hive_column_bhngv_553 char(25), hive_column_bhngv_554 boolean, hive_column_bhngv_555 int, hive_column_bhngv_556 varchar(25), hive_column_bhngv_557 decimal(38,18), hive_column_bhngv_558 timestamp, hive_column_bhngv_559 smallint, hive_column_bhngv_560 boolean, hive_column_bhngv_561 boolean, hive_column_bhngv_562 timestamp, hive_column_bhngv_563 varchar(25), hive_column_bhngv_564 smallint, hive_column_bhngv_565 char(25), hive_column_bhngv_566 int, hive_column_bhngv_567 char(25), hive_column_bhngv_568 boolean, hive_column_bhngv_569 int, hive_column_bhngv_570 decimal(38,18), hive_column_bhngv_571 boolean, hive_column_bhngv_572 char(25), hive_column_bhngv_573 string, hive_column_bhngv_574 char(25), hive_column_bhngv_575 int, hive_column_bhngv_576 int, hive_column_bhngv_577 date, hive_column_bhngv_578 timestamp, hive_column_bhngv_579 smallint, hive_column_bhngv_580 float, hive_column_bhngv_581 double, hive_column_bhngv_582 char(25), hive_column_bhngv_583 decimal(38,18), hive_column_bhngv_584 double, hive_column_bhngv_585 smallint, hive_column_bhngv_586 bigint, hive_column_bhngv_587 date, hive_column_bhngv_588 boolean, hive_column_bhngv_589 timestamp, hive_column_bhngv_590 char(25), hive_column_bhngv_591 double, hive_column_bhngv_592 char(25), hive_column_bhngv_593 smallint, hive_column_bhngv_594 date, hive_column_bhngv_595 date, hive_column_bhngv_596 smallint, hive_column_bhngv_597 date, hive_column_bhngv_598 decimal(38,18), hive_column_bhngv_599 int, hive_column_bhngv_600 smallint, hive_column_bhngv_601 double, hive_column_bhngv_602 timestamp, hive_column_bhngv_603 string, hive_column_bhngv_604 char(25), hive_column_bhngv_605 char(25), hive_column_bhngv_606 int, hive_column_bhngv_607 int, hive_column_bhngv_608 int, hive_column_bhngv_609 varchar(25), hive_column_bhngv_610 date, hive_column_bhngv_611 char(25), hive_column_bhngv_612 float, hive_column_bhngv_613 double, hive_column_bhngv_614 smallint, hive_column_bhngv_615 float, hive_column_bhngv_616 varchar(25), hive_column_bhngv_617 int, hive_column_bhngv_618 float, hive_column_bhngv_619 string, hive_column_bhngv_620 decimal(38,18), hive_column_bhngv_621 boolean, hive_column_bhngv_622 smallint, hive_column_bhngv_623 bigint, hive_column_bhngv_624 date, hive_column_bhngv_625 float, hive_column_bhngv_626 boolean, hive_column_bhngv_627 int, hive_column_bhngv_628 double, hive_column_bhngv_629 smallint, hive_column_bhngv_630 decimal(38,18), hive_column_bhngv_631 smallint, hive_column_bhngv_632 bigint, hive_column_bhngv_633 smallint, hive_column_bhngv_634 decimal(38,18), hive_column_bhngv_635 double, hive_column_bhngv_636 smallint, hive_column_bhngv_637 bigint, hive_column_bhngv_638 int, hive_column_bhngv_639 char(25), hive_column_bhngv_640 float, hive_column_bhngv_641 double, hive_column_bhngv_642 boolean, hive_column_bhngv_643 decimal(38,18), hive_column_bhngv_644 decimal(38,18), hive_column_bhngv_645 float, hive_column_bhngv_646 smallint, hive_column_bhngv_647 timestamp, hive_column_bhngv_648 string, hive_column_bhngv_649 float, hive_column_bhngv_650 timestamp, hive_column_bhngv_651 char(25), hive_column_bhngv_652 char(25), hive_column_bhngv_653 timestamp, hive_column_bhngv_654 boolean, hive_column_bhngv_655 timestamp, hive_column_bhngv_656 timestamp, hive_column_bhngv_657 char(25), hive_column_bhngv_658 date, hive_column_bhngv_659 float, hive_column_bhngv_660 string, hive_column_bhngv_661 int, hive_column_bhngv_662 char(25), hive_column_bhngv_663 int, hive_column_bhngv_664 timestamp, hive_column_bhngv_665 int, hive_column_bhngv_666 smallint, hive_column_bhngv_667 char(25), hive_column_bhngv_668 char(25), hive_column_bhngv_669 decimal(38,18), hive_column_bhngv_670 float, hive_column_bhngv_671 double, hive_column_bhngv_672 decimal(38,18), hive_column_bhngv_673 varchar(25), hive_column_bhngv_674 boolean, hive_column_bhngv_675 int, hive_column_bhngv_676 double, hive_column_bhngv_677 int, hive_column_bhngv_678 int, hive_column_bhngv_679 double, hive_column_bhngv_680 timestamp, hive_column_bhngv_681 smallint, hive_column_bhngv_682 int, hive_column_bhngv_683 float, hive_column_bhngv_684 double, hive_column_bhngv_685 decimal(38,18), hive_column_bhngv_686 decimal(38,18), hive_column_bhngv_687 int, hive_column_bhngv_688 float, hive_column_bhngv_689 double, hive_column_bhngv_690 float, hive_column_bhngv_691 timestamp, hive_column_bhngv_692 varchar(25), hive_column_bhngv_693 char(25), hive_column_bhngv_694 decimal(38,18), hive_column_bhngv_695 char(25), hive_column_bhngv_696 smallint, hive_column_bhngv_697 float, hive_column_bhngv_698 char(25), hive_column_bhngv_699 int, hive_column_bhngv_700 bigint, hive_column_bhngv_701 date, hive_column_bhngv_702 varchar(25), hive_column_bhngv_703 bigint, hive_column_bhngv_704 smallint, hive_column_bhngv_705 varchar(25), hive_column_bhngv_706 double, hive_column_bhngv_707 smallint, hive_column_bhngv_708 char(25), hive_column_bhngv_709 char(25), hive_column_bhngv_710 double, hive_column_bhngv_711 bigint, hive_column_bhngv_712 varchar(25), hive_column_bhngv_713 smallint, hive_column_bhngv_714 double, hive_column_bhngv_715 smallint, hive_column_bhngv_716 boolean, hive_column_bhngv_717 varchar(25), hive_column_bhngv_718 smallint, hive_column_bhngv_719 float, hive_column_bhngv_720 date, hive_column_bhngv_721 boolean, hive_column_bhngv_722 bigint, hive_column_bhngv_723 double, hive_column_bhngv_724 timestamp, hive_column_bhngv_725 varchar(25), hive_column_bhngv_726 double, hive_column_bhngv_727 int, hive_column_bhngv_728 float, hive_column_bhngv_729 string, hive_column_bhngv_730 string, hive_column_bhngv_731 char(25), hive_column_bhngv_732 date, hive_column_bhngv_733 bigint, hive_column_bhngv_734 varchar(25), hive_column_bhngv_735 timestamp, hive_column_bhngv_736 bigint, hive_column_bhngv_737 int, hive_column_bhngv_738 string, hive_column_bhngv_739 int, hive_column_bhngv_740 float, hive_column_bhngv_741 bigint, hive_column_bhngv_742 varchar(25), hive_column_bhngv_743 double, hive_column_bhngv_744 bigint, hive_column_bhngv_745 timestamp, hive_column_bhngv_746 date, hive_column_bhngv_747 date, hive_column_bhngv_748 float, hive_column_bhngv_749 double, hive_column_bhngv_750 char(25), hive_column_bhngv_751 float, hive_column_bhngv_752 boolean, hive_column_bhngv_753 string, hive_column_bhngv_754 float, hive_column_bhngv_755 boolean, hive_column_bhngv_756 double, hive_column_bhngv_757 boolean, hive_column_bhngv_758 char(25), hive_column_bhngv_759 decimal(38,18), hive_column_bhngv_760 int, hive_column_bhngv_761 float, hive_column_bhngv_762 double, hive_column_bhngv_763 varchar(25), hive_column_bhngv_764 varchar(25), hive_column_bhngv_765 bigint, hive_column_bhngv_766 smallint, hive_column_bhngv_767 int, hive_column_bhngv_768 date, hive_column_bhngv_769 string, hive_column_bhngv_770 bigint, hive_column_bhngv_771 double, hive_column_bhngv_772 timestamp, hive_column_bhngv_773 double, hive_column_bhngv_774 smallint, hive_column_bhngv_775 varchar(25), hive_column_bhngv_776 string, hive_column_bhngv_777 boolean, hive_column_bhngv_778 date, hive_column_bhngv_779 bigint, hive_column_bhngv_780 smallint, hive_column_bhngv_781 smallint, hive_column_bhngv_782 char(25), hive_column_bhngv_783 timestamp, hive_column_bhngv_784 string, hive_column_bhngv_785 float, hive_column_bhngv_786 date, hive_column_bhngv_787 float, hive_column_bhngv_788 float, hive_column_bhngv_789 decimal(38,18), hive_column_bhngv_790 string, hive_column_bhngv_791 double, hive_column_bhngv_792 date, hive_column_bhngv_793 double, hive_column_bhngv_794 smallint, hive_column_bhngv_795 boolean, hive_column_bhngv_796 smallint, hive_column_bhngv_797 int, hive_column_bhngv_798 char(25), hive_column_bhngv_799 string, hive_column_bhngv_800 string, hive_column_bhngv_801 double, hive_column_bhngv_802 float, hive_column_bhngv_803 decimal(38,18), hive_column_bhngv_804 boolean, hive_column_bhngv_805 boolean, hive_column_bhngv_806 char(25), hive_column_bhngv_807 string, hive_column_bhngv_808 string, hive_column_bhngv_809 timestamp, hive_column_bhngv_810 smallint, hive_column_bhngv_811 string, hive_column_bhngv_812 decimal(38,18), hive_column_bhngv_813 timestamp, hive_column_bhngv_814 smallint, hive_column_bhngv_815 float, hive_column_bhngv_816 string, hive_column_bhngv_817 char(25), hive_column_bhngv_818 smallint, hive_column_bhngv_819 varchar(25), hive_column_bhngv_820 boolean, hive_column_bhngv_821 string, hive_column_bhngv_822 bigint, hive_column_bhngv_823 smallint, hive_column_bhngv_824 int, hive_column_bhngv_825 boolean, hive_column_bhngv_826 timestamp, hive_column_bhngv_827 varchar(25), hive_column_bhngv_828 date, hive_column_bhngv_829 timestamp, hive_column_bhngv_830 boolean, hive_column_bhngv_831 boolean, hive_column_bhngv_832 date, hive_column_bhngv_833 decimal(38,18), hive_column_bhngv_834 bigint, hive_column_bhngv_835 timestamp, hive_column_bhngv_836 date, hive_column_bhngv_837 int, hive_column_bhngv_838 decimal(38,18), hive_column_bhngv_839 decimal(38,18), hive_column_bhngv_840 float, hive_column_bhngv_841 bigint, hive_column_bhngv_842 boolean, hive_column_bhngv_843 timestamp, hive_column_bhngv_844 double, hive_column_bhngv_845 decimal(38,18), hive_column_bhngv_846 decimal(38,18), hive_column_bhngv_847 char(25), hive_column_bhngv_848 char(25), hive_column_bhngv_849 string, hive_column_bhngv_850 boolean, hive_column_bhngv_851 timestamp, hive_column_bhngv_852 int, hive_column_bhngv_853 boolean, hive_column_bhngv_854 varchar(25), hive_column_bhngv_855 timestamp, hive_column_bhngv_856 varchar(25), hive_column_bhngv_857 timestamp, hive_column_bhngv_858 float, hive_column_bhngv_859 boolean, hive_column_bhngv_860 smallint, hive_column_bhngv_861 smallint, hive_column_bhngv_862 bigint, hive_column_bhngv_863 double, hive_column_bhngv_864 varchar(25), hive_column_bhngv_865 string, hive_column_bhngv_866 varchar(25), hive_column_bhngv_867 string, hive_column_bhngv_868 bigint, hive_column_bhngv_869 date, hive_column_bhngv_870 bigint, hive_column_bhngv_871 decimal(38,18), hive_column_bhngv_872 decimal(38,18), hive_column_bhngv_873 decimal(38,18), hive_column_bhngv_874 char(25), hive_column_bhngv_875 float, hive_column_bhngv_876 int, hive_column_bhngv_877 smallint, hive_column_bhngv_878 char(25), hive_column_bhngv_879 smallint, hive_column_bhngv_880 decimal(38,18), hive_column_bhngv_881 bigint, hive_column_bhngv_882 bigint, hive_column_bhngv_883 float, hive_column_bhngv_884 smallint, hive_column_bhngv_885 varchar(25), hive_column_bhngv_886 varchar(25), hive_column_bhngv_887 date, hive_column_bhngv_888 bigint, hive_column_bhngv_889 int, hive_column_bhngv_890 double, hive_column_bhngv_891 int, hive_column_bhngv_892 string, hive_column_bhngv_893 timestamp, hive_column_bhngv_894 string, hive_column_bhngv_895 string, hive_column_bhngv_896 bigint, hive_column_bhngv_897 boolean, hive_column_bhngv_898 double, hive_column_bhngv_899 varchar(25), hive_column_bhngv_900 double, hive_column_bhngv_901 int, hive_column_bhngv_902 double, hive_column_bhngv_903 char(25), hive_column_bhngv_904 bigint, hive_column_bhngv_905 int, hive_column_bhngv_906 smallint, hive_column_bhngv_907 char(25), hive_column_bhngv_908 double, hive_column_bhngv_909 smallint, hive_column_bhngv_910 bigint, hive_column_bhngv_911 float, hive_column_bhngv_912 char(25), hive_column_bhngv_913 bigint, hive_column_bhngv_914 int, hive_column_bhngv_915 bigint, hive_column_bhngv_916 char(25), hive_column_bhngv_917 decimal(38,18), hive_column_bhngv_918 date, hive_column_bhngv_919 smallint, hive_column_bhngv_920 char(25), hive_column_bhngv_921 boolean, hive_column_bhngv_922 date, hive_column_bhngv_923 string, hive_column_bhngv_924 smallint, hive_column_bhngv_925 char(25), hive_column_bhngv_926 char(25), hive_column_bhngv_927 smallint, hive_column_bhngv_928 boolean, hive_column_bhngv_929 boolean, hive_column_bhngv_930 date, hive_column_bhngv_931 decimal(38,18), hive_column_bhngv_932 date, hive_column_bhngv_933 char(25), hive_column_bhngv_934 timestamp, hive_column_bhngv_935 double, hive_column_bhngv_936 char(25), hive_column_bhngv_937 timestamp, hive_column_bhngv_938 int, hive_column_bhngv_939 smallint, hive_column_bhngv_940 smallint, hive_column_bhngv_941 double, hive_column_bhngv_942 float, hive_column_bhngv_943 timestamp, hive_column_bhngv_944 string, hive_column_bhngv_945 boolean, hive_column_bhngv_946 double, hive_column_bhngv_947 smallint, hive_column_bhngv_948 timestamp, hive_column_bhngv_949 int, hive_column_bhngv_950 timestamp, hive_column_bhngv_951 smallint, hive_column_bhngv_952 varchar(25), hive_column_bhngv_953 date, hive_column_bhngv_954 timestamp, hive_column_bhngv_955 double, hive_column_bhngv_956 bigint, hive_column_bhngv_957 string, hive_column_bhngv_958 bigint, hive_column_bhngv_959 smallint, hive_column_bhngv_960 bigint, hive_column_bhngv_961 float, hive_column_bhngv_962 date, hive_column_bhngv_963 decimal(38,18), hive_column_bhngv_964 char(25), hive_column_bhngv_965 double, hive_column_bhngv_966 date, hive_column_bhngv_967 varchar(25), hive_column_bhngv_968 double, hive_column_bhngv_969 timestamp, hive_column_bhngv_970 smallint, hive_column_bhngv_971 date, hive_column_bhngv_972 decimal(38,18), hive_column_bhngv_973 float, hive_column_bhngv_974 varchar(25), hive_column_bhngv_975 date, hive_column_bhngv_976 varchar(25), hive_column_bhngv_977 bigint, hive_column_bhngv_978 date, hive_column_bhngv_979 float, hive_column_bhngv_980 date, hive_column_bhngv_981 float, hive_column_bhngv_982 date, hive_column_bhngv_983 double, hive_column_bhngv_984 boolean, hive_column_bhngv_985 int, hive_column_bhngv_986 int, hive_column_bhngv_987 bigint, hive_column_bhngv_988 int, hive_column_bhngv_989 date, hive_column_bhngv_990 boolean, hive_column_bhngv_991 double, hive_column_bhngv_992 varchar(25), hive_column_bhngv_993 boolean, hive_column_bhngv_994 timestamp, hive_column_bhngv_995 double, hive_column_bhngv_996 smallint, hive_column_bhngv_997 boolean, hive_column_bhngv_998 float, hive_column_bhngv_999 boolean, hive_column_bhngv_1000 double);"