New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for querying data in a table with a very large number of columns. #1159

Closed
Taehui opened this Issue Dec 26, 2018 · 6 comments

Comments

Projects
None yet
4 participants
@Taehui
Copy link
Collaborator

Taehui commented Dec 26, 2018

Describe the bug

  • 컬럼 갯수가 매우 많은 테이블(하이브)에 대해서 쿼리 실행 시 깜박거리는 현상의 무한반복...

https://files.slack.com/files-pri/TCU6WQ88N-FEZPMC5PD/download/20181221_092735.mp4

To Reproduce
Steps to reproduce the behavior:

  1. 컬럼 갯수가 500 개 이상 테이블 t1 을 생성
  2. 다음 쿼리 실행 : SELECT * FROM t1 ;

Expected behavior

  • 갯수가 많아도 정상적으로 조회되어야 함
@Taehui

This comment has been minimized.

Copy link
Collaborator Author

Taehui commented Jan 7, 2019

@ufoscw 이 이슈 검토 부탁드립니다.

@ufoscw

This comment has been minimized.

Copy link
Contributor

ufoscw commented Jan 9, 2019

@YooYoungmo
쿼리 결과 저장시 발생하는 에러로 보이는데
혹시 해당 오류 검토가 가능하실까요?

@YooYoungmo

This comment has been minimized.

Copy link
Collaborator

YooYoungmo commented Jan 9, 2019

@ufoscw 확인해 보겠습니다.

@YooYoungmo YooYoungmo self-assigned this Jan 9, 2019

@YooYoungmo

This comment has been minimized.

Copy link
Collaborator

YooYoungmo commented Jan 9, 2019

@ufoscw 문제 확인 했습니다. 말씀 하신데로 쿼리 결과 저장 시에 발생하는 오류 입니다. 이 이슈는 제가 진행 하겠습니다.

@YooYoungmo

This comment has been minimized.

Copy link
Collaborator

YooYoungmo commented Jan 10, 2019

오류 재현

  • 메타트론 DB를 MySQL로 사용 시 재현됨(H2 데이터베이스의 경우 발생하지 않음)
  • MySQL 데이터베이스에 컬럼 600개의 t1 테이블 생성
CREATE TABLE`t1` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `abcd_vca_ssss_abc0` VARCHAR(100) NULL,
`abcd_vca_ssss_abc1` VARCHAR(100) NULL,
`abcd_vca_ssss_abc2` VARCHAR(100) NULL,
`abcd_vca_ssss_abc3` VARCHAR(100) NULL,
`abcd_vca_ssss_abc4` VARCHAR(100) NULL,
`abcd_vca_ssss_abc5` VARCHAR(100) NULL,
`abcd_vca_ssss_abc6` VARCHAR(100) NULL,
`abcd_vca_ssss_abc7` VARCHAR(100) NULL,
`abcd_vca_ssss_abc8` VARCHAR(100) NULL,
`abcd_vca_ssss_abc9` VARCHAR(100) NULL,
`abcd_vca_ssss_abc10` VARCHAR(100) NULL,
`abcd_vca_ssss_abc11` VARCHAR(100) NULL,
`abcd_vca_ssss_abc12` VARCHAR(100) NULL,
`abcd_vca_ssss_abc13` VARCHAR(100) NULL,
`abcd_vca_ssss_abc14` VARCHAR(100) NULL,
`abcd_vca_ssss_abc15` VARCHAR(100) NULL,
`abcd_vca_ssss_abc16` VARCHAR(100) NULL,
`abcd_vca_ssss_abc17` VARCHAR(100) NULL,
`abcd_vca_ssss_abc18` VARCHAR(100) NULL,
`abcd_vca_ssss_abc19` VARCHAR(100) NULL,
`abcd_vca_ssss_abc20` VARCHAR(100) NULL,
`abcd_vca_ssss_abc21` VARCHAR(100) NULL,
`abcd_vca_ssss_abc22` VARCHAR(100) NULL,
`abcd_vca_ssss_abc23` VARCHAR(100) NULL,
`abcd_vca_ssss_abc24` VARCHAR(100) NULL,
`abcd_vca_ssss_abc25` VARCHAR(100) NULL,
`abcd_vca_ssss_abc26` VARCHAR(100) NULL,
`abcd_vca_ssss_abc27` VARCHAR(100) NULL,
`abcd_vca_ssss_abc28` VARCHAR(100) NULL,
`abcd_vca_ssss_abc29` VARCHAR(100) NULL,
`abcd_vca_ssss_abc30` VARCHAR(100) NULL,
`abcd_vca_ssss_abc31` VARCHAR(100) NULL,
`abcd_vca_ssss_abc32` VARCHAR(100) NULL,
`abcd_vca_ssss_abc33` VARCHAR(100) NULL,
`abcd_vca_ssss_abc34` VARCHAR(100) NULL,
`abcd_vca_ssss_abc35` VARCHAR(100) NULL,
`abcd_vca_ssss_abc36` VARCHAR(100) NULL,
`abcd_vca_ssss_abc37` VARCHAR(100) NULL,
`abcd_vca_ssss_abc38` VARCHAR(100) NULL,
`abcd_vca_ssss_abc39` VARCHAR(100) NULL,
`abcd_vca_ssss_abc40` VARCHAR(100) NULL,
`abcd_vca_ssss_abc41` VARCHAR(100) NULL,
`abcd_vca_ssss_abc42` VARCHAR(100) NULL,
`abcd_vca_ssss_abc43` VARCHAR(100) NULL,
`abcd_vca_ssss_abc44` VARCHAR(100) NULL,
`abcd_vca_ssss_abc45` VARCHAR(100) NULL,
`abcd_vca_ssss_abc46` VARCHAR(100) NULL,
`abcd_vca_ssss_abc47` VARCHAR(100) NULL,
`abcd_vca_ssss_abc48` VARCHAR(100) NULL,
`abcd_vca_ssss_abc49` VARCHAR(100) NULL,
`abcd_vca_ssss_abc50` VARCHAR(100) NULL,
`abcd_vca_ssss_abc51` VARCHAR(100) NULL,
`abcd_vca_ssss_abc52` VARCHAR(100) NULL,
`abcd_vca_ssss_abc53` VARCHAR(100) NULL,
`abcd_vca_ssss_abc54` VARCHAR(100) NULL,
`abcd_vca_ssss_abc55` VARCHAR(100) NULL,
`abcd_vca_ssss_abc56` VARCHAR(100) NULL,
`abcd_vca_ssss_abc57` VARCHAR(100) NULL,
`abcd_vca_ssss_abc58` VARCHAR(100) NULL,
`abcd_vca_ssss_abc59` VARCHAR(100) NULL,
`abcd_vca_ssss_abc60` VARCHAR(100) NULL,
`abcd_vca_ssss_abc61` VARCHAR(100) NULL,
`abcd_vca_ssss_abc62` VARCHAR(100) NULL,
`abcd_vca_ssss_abc63` VARCHAR(100) NULL,
`abcd_vca_ssss_abc64` VARCHAR(100) NULL,
`abcd_vca_ssss_abc65` VARCHAR(100) NULL,
`abcd_vca_ssss_abc66` VARCHAR(100) NULL,
`abcd_vca_ssss_abc67` VARCHAR(100) NULL,
`abcd_vca_ssss_abc68` VARCHAR(100) NULL,
`abcd_vca_ssss_abc69` VARCHAR(100) NULL,
`abcd_vca_ssss_abc70` VARCHAR(100) NULL,
`abcd_vca_ssss_abc71` VARCHAR(100) NULL,
`abcd_vca_ssss_abc72` VARCHAR(100) NULL,
`abcd_vca_ssss_abc73` VARCHAR(100) NULL,
`abcd_vca_ssss_abc74` VARCHAR(100) NULL,
`abcd_vca_ssss_abc75` VARCHAR(100) NULL,
`abcd_vca_ssss_abc76` VARCHAR(100) NULL,
`abcd_vca_ssss_abc77` VARCHAR(100) NULL,
`abcd_vca_ssss_abc78` VARCHAR(100) NULL,
`abcd_vca_ssss_abc79` VARCHAR(100) NULL,
`abcd_vca_ssss_abc80` VARCHAR(100) NULL,
`abcd_vca_ssss_abc81` VARCHAR(100) NULL,
`abcd_vca_ssss_abc82` VARCHAR(100) NULL,
`abcd_vca_ssss_abc83` VARCHAR(100) NULL,
`abcd_vca_ssss_abc84` VARCHAR(100) NULL,
`abcd_vca_ssss_abc85` VARCHAR(100) NULL,
`abcd_vca_ssss_abc86` VARCHAR(100) NULL,
`abcd_vca_ssss_abc87` VARCHAR(100) NULL,
`abcd_vca_ssss_abc88` VARCHAR(100) NULL,
`abcd_vca_ssss_abc89` VARCHAR(100) NULL,
`abcd_vca_ssss_abc90` VARCHAR(100) NULL,
`abcd_vca_ssss_abc91` VARCHAR(100) NULL,
`abcd_vca_ssss_abc92` VARCHAR(100) NULL,
`abcd_vca_ssss_abc93` VARCHAR(100) NULL,
`abcd_vca_ssss_abc94` VARCHAR(100) NULL,
`abcd_vca_ssss_abc95` VARCHAR(100) NULL,
`abcd_vca_ssss_abc96` VARCHAR(100) NULL,
`abcd_vca_ssss_abc97` VARCHAR(100) NULL,
`abcd_vca_ssss_abc98` VARCHAR(100) NULL,
`abcd_vca_ssss_abc99` VARCHAR(100) NULL,
`abcd_vca_ssss_abc100` VARCHAR(100) NULL,
`abcd_vca_ssss_abc101` VARCHAR(100) NULL,
`abcd_vca_ssss_abc102` VARCHAR(100) NULL,
`abcd_vca_ssss_abc103` VARCHAR(100) NULL,
`abcd_vca_ssss_abc104` VARCHAR(100) NULL,
`abcd_vca_ssss_abc105` VARCHAR(100) NULL,
`abcd_vca_ssss_abc106` VARCHAR(100) NULL,
`abcd_vca_ssss_abc107` VARCHAR(100) NULL,
`abcd_vca_ssss_abc108` VARCHAR(100) NULL,
`abcd_vca_ssss_abc109` VARCHAR(100) NULL,
`abcd_vca_ssss_abc110` VARCHAR(100) NULL,
`abcd_vca_ssss_abc111` VARCHAR(100) NULL,
`abcd_vca_ssss_abc112` VARCHAR(100) NULL,
`abcd_vca_ssss_abc113` VARCHAR(100) NULL,
`abcd_vca_ssss_abc114` VARCHAR(100) NULL,
`abcd_vca_ssss_abc115` VARCHAR(100) NULL,
`abcd_vca_ssss_abc116` VARCHAR(100) NULL,
`abcd_vca_ssss_abc117` VARCHAR(100) NULL,
`abcd_vca_ssss_abc118` VARCHAR(100) NULL,
`abcd_vca_ssss_abc119` VARCHAR(100) NULL,
`abcd_vca_ssss_abc120` VARCHAR(100) NULL,
`abcd_vca_ssss_abc121` VARCHAR(100) NULL,
`abcd_vca_ssss_abc122` VARCHAR(100) NULL,
`abcd_vca_ssss_abc123` VARCHAR(100) NULL,
`abcd_vca_ssss_abc124` VARCHAR(100) NULL,
`abcd_vca_ssss_abc125` VARCHAR(100) NULL,
`abcd_vca_ssss_abc126` VARCHAR(100) NULL,
`abcd_vca_ssss_abc127` VARCHAR(100) NULL,
`abcd_vca_ssss_abc128` VARCHAR(100) NULL,
`abcd_vca_ssss_abc129` VARCHAR(100) NULL,
`abcd_vca_ssss_abc130` VARCHAR(100) NULL,
`abcd_vca_ssss_abc131` VARCHAR(100) NULL,
`abcd_vca_ssss_abc132` VARCHAR(100) NULL,
`abcd_vca_ssss_abc133` VARCHAR(100) NULL,
`abcd_vca_ssss_abc134` VARCHAR(100) NULL,
`abcd_vca_ssss_abc135` VARCHAR(100) NULL,
`abcd_vca_ssss_abc136` VARCHAR(100) NULL,
`abcd_vca_ssss_abc137` VARCHAR(100) NULL,
`abcd_vca_ssss_abc138` VARCHAR(100) NULL,
`abcd_vca_ssss_abc139` VARCHAR(100) NULL,
`abcd_vca_ssss_abc140` VARCHAR(100) NULL,
`abcd_vca_ssss_abc141` VARCHAR(100) NULL,
`abcd_vca_ssss_abc142` VARCHAR(100) NULL,
`abcd_vca_ssss_abc143` VARCHAR(100) NULL,
`abcd_vca_ssss_abc144` VARCHAR(100) NULL,
`abcd_vca_ssss_abc145` VARCHAR(100) NULL,
`abcd_vca_ssss_abc146` VARCHAR(100) NULL,
`abcd_vca_ssss_abc147` VARCHAR(100) NULL,
`abcd_vca_ssss_abc148` VARCHAR(100) NULL,
`abcd_vca_ssss_abc149` VARCHAR(100) NULL,
`abcd_vca_ssss_abc150` VARCHAR(100) NULL,
`abcd_vca_ssss_abc151` VARCHAR(100) NULL,
`abcd_vca_ssss_abc152` VARCHAR(100) NULL,
`abcd_vca_ssss_abc153` VARCHAR(100) NULL,
`abcd_vca_ssss_abc154` VARCHAR(100) NULL,
`abcd_vca_ssss_abc155` VARCHAR(100) NULL,
`abcd_vca_ssss_abc156` VARCHAR(100) NULL,
`abcd_vca_ssss_abc157` VARCHAR(100) NULL,
`abcd_vca_ssss_abc158` VARCHAR(100) NULL,
`abcd_vca_ssss_abc159` VARCHAR(100) NULL,
`abcd_vca_ssss_abc160` VARCHAR(100) NULL,
`abcd_vca_ssss_abc161` VARCHAR(100) NULL,
`abcd_vca_ssss_abc162` VARCHAR(100) NULL,
`abcd_vca_ssss_abc163` VARCHAR(100) NULL,
`abcd_vca_ssss_abc164` VARCHAR(100) NULL,
`abcd_vca_ssss_abc165` VARCHAR(100) NULL,
`abcd_vca_ssss_abc166` VARCHAR(100) NULL,
`abcd_vca_ssss_abc167` VARCHAR(100) NULL,
`abcd_vca_ssss_abc168` VARCHAR(100) NULL,
`abcd_vca_ssss_abc169` VARCHAR(100) NULL,
`abcd_vca_ssss_abc170` VARCHAR(100) NULL,
`abcd_vca_ssss_abc171` VARCHAR(100) NULL,
`abcd_vca_ssss_abc172` VARCHAR(100) NULL,
`abcd_vca_ssss_abc173` VARCHAR(100) NULL,
`abcd_vca_ssss_abc174` VARCHAR(100) NULL,
`abcd_vca_ssss_abc175` VARCHAR(100) NULL,
`abcd_vca_ssss_abc176` VARCHAR(100) NULL,
`abcd_vca_ssss_abc177` VARCHAR(100) NULL,
`abcd_vca_ssss_abc178` VARCHAR(100) NULL,
`abcd_vca_ssss_abc179` VARCHAR(100) NULL,
`abcd_vca_ssss_abc180` VARCHAR(100) NULL,
`abcd_vca_ssss_abc181` VARCHAR(100) NULL,
`abcd_vca_ssss_abc182` VARCHAR(100) NULL,
`abcd_vca_ssss_abc183` VARCHAR(100) NULL,
`abcd_vca_ssss_abc184` VARCHAR(100) NULL,
`abcd_vca_ssss_abc185` VARCHAR(100) NULL,
`abcd_vca_ssss_abc186` VARCHAR(100) NULL,
`abcd_vca_ssss_abc187` VARCHAR(100) NULL,
`abcd_vca_ssss_abc188` VARCHAR(100) NULL,
`abcd_vca_ssss_abc189` VARCHAR(100) NULL,
`abcd_vca_ssss_abc190` VARCHAR(100) NULL,
`abcd_vca_ssss_abc191` VARCHAR(100) NULL,
`abcd_vca_ssss_abc192` VARCHAR(100) NULL,
`abcd_vca_ssss_abc193` VARCHAR(100) NULL,
`abcd_vca_ssss_abc194` VARCHAR(100) NULL,
`abcd_vca_ssss_abc195` VARCHAR(100) NULL,
`abcd_vca_ssss_abc196` VARCHAR(100) NULL,
`abcd_vca_ssss_abc197` VARCHAR(100) NULL,
`abcd_vca_ssss_abc198` VARCHAR(100) NULL,
`abcd_vca_ssss_abc199` VARCHAR(100) NULL,
`abcd_vca_ssss_abc200` VARCHAR(100) NULL,
`abcd_vca_ssss_abc201` VARCHAR(100) NULL,
`abcd_vca_ssss_abc202` VARCHAR(100) NULL,
`abcd_vca_ssss_abc203` VARCHAR(100) NULL,
`abcd_vca_ssss_abc204` VARCHAR(100) NULL,
`abcd_vca_ssss_abc205` VARCHAR(100) NULL,
`abcd_vca_ssss_abc206` VARCHAR(100) NULL,
`abcd_vca_ssss_abc207` VARCHAR(100) NULL,
`abcd_vca_ssss_abc208` VARCHAR(100) NULL,
`abcd_vca_ssss_abc209` VARCHAR(100) NULL,
`abcd_vca_ssss_abc210` VARCHAR(100) NULL,
`abcd_vca_ssss_abc211` VARCHAR(100) NULL,
`abcd_vca_ssss_abc212` VARCHAR(100) NULL,
`abcd_vca_ssss_abc213` VARCHAR(100) NULL,
`abcd_vca_ssss_abc214` VARCHAR(100) NULL,
`abcd_vca_ssss_abc215` VARCHAR(100) NULL,
`abcd_vca_ssss_abc216` VARCHAR(100) NULL,
`abcd_vca_ssss_abc217` VARCHAR(100) NULL,
`abcd_vca_ssss_abc218` VARCHAR(100) NULL,
`abcd_vca_ssss_abc219` VARCHAR(100) NULL,
`abcd_vca_ssss_abc220` VARCHAR(100) NULL,
`abcd_vca_ssss_abc221` VARCHAR(100) NULL,
`abcd_vca_ssss_abc222` VARCHAR(100) NULL,
`abcd_vca_ssss_abc223` VARCHAR(100) NULL,
`abcd_vca_ssss_abc224` VARCHAR(100) NULL,
`abcd_vca_ssss_abc225` VARCHAR(100) NULL,
`abcd_vca_ssss_abc226` VARCHAR(100) NULL,
`abcd_vca_ssss_abc227` VARCHAR(100) NULL,
`abcd_vca_ssss_abc228` VARCHAR(100) NULL,
`abcd_vca_ssss_abc229` VARCHAR(100) NULL,
`abcd_vca_ssss_abc230` VARCHAR(100) NULL,
`abcd_vca_ssss_abc231` VARCHAR(100) NULL,
`abcd_vca_ssss_abc232` VARCHAR(100) NULL,
`abcd_vca_ssss_abc233` VARCHAR(100) NULL,
`abcd_vca_ssss_abc234` VARCHAR(100) NULL,
`abcd_vca_ssss_abc235` VARCHAR(100) NULL,
`abcd_vca_ssss_abc236` VARCHAR(100) NULL,
`abcd_vca_ssss_abc237` VARCHAR(100) NULL,
`abcd_vca_ssss_abc238` VARCHAR(100) NULL,
`abcd_vca_ssss_abc239` VARCHAR(100) NULL,
`abcd_vca_ssss_abc240` VARCHAR(100) NULL,
`abcd_vca_ssss_abc241` VARCHAR(100) NULL,
`abcd_vca_ssss_abc242` VARCHAR(100) NULL,
`abcd_vca_ssss_abc243` VARCHAR(100) NULL,
`abcd_vca_ssss_abc244` VARCHAR(100) NULL,
`abcd_vca_ssss_abc245` VARCHAR(100) NULL,
`abcd_vca_ssss_abc246` VARCHAR(100) NULL,
`abcd_vca_ssss_abc247` VARCHAR(100) NULL,
`abcd_vca_ssss_abc248` VARCHAR(100) NULL,
`abcd_vca_ssss_abc249` VARCHAR(100) NULL,
`abcd_vca_ssss_abc250` VARCHAR(100) NULL,
`abcd_vca_ssss_abc251` VARCHAR(100) NULL,
`abcd_vca_ssss_abc252` VARCHAR(100) NULL,
`abcd_vca_ssss_abc253` VARCHAR(100) NULL,
`abcd_vca_ssss_abc254` VARCHAR(100) NULL,
`abcd_vca_ssss_abc255` VARCHAR(100) NULL,
`abcd_vca_ssss_abc256` VARCHAR(100) NULL,
`abcd_vca_ssss_abc257` VARCHAR(100) NULL,
`abcd_vca_ssss_abc258` VARCHAR(100) NULL,
`abcd_vca_ssss_abc259` VARCHAR(100) NULL,
`abcd_vca_ssss_abc260` VARCHAR(100) NULL,
`abcd_vca_ssss_abc261` VARCHAR(100) NULL,
`abcd_vca_ssss_abc262` VARCHAR(100) NULL,
`abcd_vca_ssss_abc263` VARCHAR(100) NULL,
`abcd_vca_ssss_abc264` VARCHAR(100) NULL,
`abcd_vca_ssss_abc265` VARCHAR(100) NULL,
`abcd_vca_ssss_abc266` VARCHAR(100) NULL,
`abcd_vca_ssss_abc267` VARCHAR(100) NULL,
`abcd_vca_ssss_abc268` VARCHAR(100) NULL,
`abcd_vca_ssss_abc269` VARCHAR(100) NULL,
`abcd_vca_ssss_abc270` VARCHAR(100) NULL,
`abcd_vca_ssss_abc271` VARCHAR(100) NULL,
`abcd_vca_ssss_abc272` VARCHAR(100) NULL,
`abcd_vca_ssss_abc273` VARCHAR(100) NULL,
`abcd_vca_ssss_abc274` VARCHAR(100) NULL,
`abcd_vca_ssss_abc275` VARCHAR(100) NULL,
`abcd_vca_ssss_abc276` VARCHAR(100) NULL,
`abcd_vca_ssss_abc277` VARCHAR(100) NULL,
`abcd_vca_ssss_abc278` VARCHAR(100) NULL,
`abcd_vca_ssss_abc279` VARCHAR(100) NULL,
`abcd_vca_ssss_abc280` VARCHAR(100) NULL,
`abcd_vca_ssss_abc281` VARCHAR(100) NULL,
`abcd_vca_ssss_abc282` VARCHAR(100) NULL,
`abcd_vca_ssss_abc283` VARCHAR(100) NULL,
`abcd_vca_ssss_abc284` VARCHAR(100) NULL,
`abcd_vca_ssss_abc285` VARCHAR(100) NULL,
`abcd_vca_ssss_abc286` VARCHAR(100) NULL,
`abcd_vca_ssss_abc287` VARCHAR(100) NULL,
`abcd_vca_ssss_abc288` VARCHAR(100) NULL,
`abcd_vca_ssss_abc289` VARCHAR(100) NULL,
`abcd_vca_ssss_abc290` VARCHAR(100) NULL,
`abcd_vca_ssss_abc291` VARCHAR(100) NULL,
`abcd_vca_ssss_abc292` VARCHAR(100) NULL,
`abcd_vca_ssss_abc293` VARCHAR(100) NULL,
`abcd_vca_ssss_abc294` VARCHAR(100) NULL,
`abcd_vca_ssss_abc295` VARCHAR(100) NULL,
`abcd_vca_ssss_abc296` VARCHAR(100) NULL,
`abcd_vca_ssss_abc297` VARCHAR(100) NULL,
`abcd_vca_ssss_abc298` VARCHAR(100) NULL,
`abcd_vca_ssss_abc299` VARCHAR(100) NULL,
`abcd_vca_ssss_abc300` VARCHAR(100) NULL,
`abcd_vca_ssss_abc301` VARCHAR(100) NULL,
`abcd_vca_ssss_abc302` VARCHAR(100) NULL,
`abcd_vca_ssss_abc303` VARCHAR(100) NULL,
`abcd_vca_ssss_abc304` VARCHAR(100) NULL,
`abcd_vca_ssss_abc305` VARCHAR(100) NULL,
`abcd_vca_ssss_abc306` VARCHAR(100) NULL,
`abcd_vca_ssss_abc307` VARCHAR(100) NULL,
`abcd_vca_ssss_abc308` VARCHAR(100) NULL,
`abcd_vca_ssss_abc309` VARCHAR(100) NULL,
`abcd_vca_ssss_abc310` VARCHAR(100) NULL,
`abcd_vca_ssss_abc311` VARCHAR(100) NULL,
`abcd_vca_ssss_abc312` VARCHAR(100) NULL,
`abcd_vca_ssss_abc313` VARCHAR(100) NULL,
`abcd_vca_ssss_abc314` VARCHAR(100) NULL,
`abcd_vca_ssss_abc315` VARCHAR(100) NULL,
`abcd_vca_ssss_abc316` VARCHAR(100) NULL,
`abcd_vca_ssss_abc317` VARCHAR(100) NULL,
`abcd_vca_ssss_abc318` VARCHAR(100) NULL,
`abcd_vca_ssss_abc319` VARCHAR(100) NULL,
`abcd_vca_ssss_abc320` VARCHAR(100) NULL,
`abcd_vca_ssss_abc321` VARCHAR(100) NULL,
`abcd_vca_ssss_abc322` VARCHAR(100) NULL,
`abcd_vca_ssss_abc323` VARCHAR(100) NULL,
`abcd_vca_ssss_abc324` VARCHAR(100) NULL,
`abcd_vca_ssss_abc325` VARCHAR(100) NULL,
`abcd_vca_ssss_abc326` VARCHAR(100) NULL,
`abcd_vca_ssss_abc327` VARCHAR(100) NULL,
`abcd_vca_ssss_abc328` VARCHAR(100) NULL,
`abcd_vca_ssss_abc329` VARCHAR(100) NULL,
`abcd_vca_ssss_abc330` VARCHAR(100) NULL,
`abcd_vca_ssss_abc331` VARCHAR(100) NULL,
`abcd_vca_ssss_abc332` VARCHAR(100) NULL,
`abcd_vca_ssss_abc333` VARCHAR(100) NULL,
`abcd_vca_ssss_abc334` VARCHAR(100) NULL,
`abcd_vca_ssss_abc335` VARCHAR(100) NULL,
`abcd_vca_ssss_abc336` VARCHAR(100) NULL,
`abcd_vca_ssss_abc337` VARCHAR(100) NULL,
`abcd_vca_ssss_abc338` VARCHAR(100) NULL,
`abcd_vca_ssss_abc339` VARCHAR(100) NULL,
`abcd_vca_ssss_abc340` VARCHAR(100) NULL,
`abcd_vca_ssss_abc341` VARCHAR(100) NULL,
`abcd_vca_ssss_abc342` VARCHAR(100) NULL,
`abcd_vca_ssss_abc343` VARCHAR(100) NULL,
`abcd_vca_ssss_abc344` VARCHAR(100) NULL,
`abcd_vca_ssss_abc345` VARCHAR(100) NULL,
`abcd_vca_ssss_abc346` VARCHAR(100) NULL,
`abcd_vca_ssss_abc347` VARCHAR(100) NULL,
`abcd_vca_ssss_abc348` VARCHAR(100) NULL,
`abcd_vca_ssss_abc349` VARCHAR(100) NULL,
`abcd_vca_ssss_abc350` VARCHAR(100) NULL,
`abcd_vca_ssss_abc351` VARCHAR(100) NULL,
`abcd_vca_ssss_abc352` VARCHAR(100) NULL,
`abcd_vca_ssss_abc353` VARCHAR(100) NULL,
`abcd_vca_ssss_abc354` VARCHAR(100) NULL,
`abcd_vca_ssss_abc355` VARCHAR(100) NULL,
`abcd_vca_ssss_abc356` VARCHAR(100) NULL,
`abcd_vca_ssss_abc357` VARCHAR(100) NULL,
`abcd_vca_ssss_abc358` VARCHAR(100) NULL,
`abcd_vca_ssss_abc359` VARCHAR(100) NULL,
`abcd_vca_ssss_abc360` VARCHAR(100) NULL,
`abcd_vca_ssss_abc361` VARCHAR(100) NULL,
`abcd_vca_ssss_abc362` VARCHAR(100) NULL,
`abcd_vca_ssss_abc363` VARCHAR(100) NULL,
`abcd_vca_ssss_abc364` VARCHAR(100) NULL,
`abcd_vca_ssss_abc365` VARCHAR(100) NULL,
`abcd_vca_ssss_abc366` VARCHAR(100) NULL,
`abcd_vca_ssss_abc367` VARCHAR(100) NULL,
`abcd_vca_ssss_abc368` VARCHAR(100) NULL,
`abcd_vca_ssss_abc369` VARCHAR(100) NULL,
`abcd_vca_ssss_abc370` VARCHAR(100) NULL,
`abcd_vca_ssss_abc371` VARCHAR(100) NULL,
`abcd_vca_ssss_abc372` VARCHAR(100) NULL,
`abcd_vca_ssss_abc373` VARCHAR(100) NULL,
`abcd_vca_ssss_abc374` VARCHAR(100) NULL,
`abcd_vca_ssss_abc375` VARCHAR(100) NULL,
`abcd_vca_ssss_abc376` VARCHAR(100) NULL,
`abcd_vca_ssss_abc377` VARCHAR(100) NULL,
`abcd_vca_ssss_abc378` VARCHAR(100) NULL,
`abcd_vca_ssss_abc379` VARCHAR(100) NULL,
`abcd_vca_ssss_abc380` VARCHAR(100) NULL,
`abcd_vca_ssss_abc381` VARCHAR(100) NULL,
`abcd_vca_ssss_abc382` VARCHAR(100) NULL,
`abcd_vca_ssss_abc383` VARCHAR(100) NULL,
`abcd_vca_ssss_abc384` VARCHAR(100) NULL,
`abcd_vca_ssss_abc385` VARCHAR(100) NULL,
`abcd_vca_ssss_abc386` VARCHAR(100) NULL,
`abcd_vca_ssss_abc387` VARCHAR(100) NULL,
`abcd_vca_ssss_abc388` VARCHAR(100) NULL,
`abcd_vca_ssss_abc389` VARCHAR(100) NULL,
`abcd_vca_ssss_abc390` VARCHAR(100) NULL,
`abcd_vca_ssss_abc391` VARCHAR(100) NULL,
`abcd_vca_ssss_abc392` VARCHAR(100) NULL,
`abcd_vca_ssss_abc393` VARCHAR(100) NULL,
`abcd_vca_ssss_abc394` VARCHAR(100) NULL,
`abcd_vca_ssss_abc395` VARCHAR(100) NULL,
`abcd_vca_ssss_abc396` VARCHAR(100) NULL,
`abcd_vca_ssss_abc397` VARCHAR(100) NULL,
`abcd_vca_ssss_abc398` VARCHAR(100) NULL,
`abcd_vca_ssss_abc399` VARCHAR(100) NULL,
`abcd_vca_ssss_abc400` VARCHAR(100) NULL,
`abcd_vca_ssss_abc401` VARCHAR(100) NULL,
`abcd_vca_ssss_abc402` VARCHAR(100) NULL,
`abcd_vca_ssss_abc403` VARCHAR(100) NULL,
`abcd_vca_ssss_abc404` VARCHAR(100) NULL,
`abcd_vca_ssss_abc405` VARCHAR(100) NULL,
`abcd_vca_ssss_abc406` VARCHAR(100) NULL,
`abcd_vca_ssss_abc407` VARCHAR(100) NULL,
`abcd_vca_ssss_abc408` VARCHAR(100) NULL,
`abcd_vca_ssss_abc409` VARCHAR(100) NULL,
`abcd_vca_ssss_abc410` VARCHAR(100) NULL,
`abcd_vca_ssss_abc411` VARCHAR(100) NULL,
`abcd_vca_ssss_abc412` VARCHAR(100) NULL,
`abcd_vca_ssss_abc413` VARCHAR(100) NULL,
`abcd_vca_ssss_abc414` VARCHAR(100) NULL,
`abcd_vca_ssss_abc415` VARCHAR(100) NULL,
`abcd_vca_ssss_abc416` VARCHAR(100) NULL,
`abcd_vca_ssss_abc417` VARCHAR(100) NULL,
`abcd_vca_ssss_abc418` VARCHAR(100) NULL,
`abcd_vca_ssss_abc419` VARCHAR(100) NULL,
`abcd_vca_ssss_abc420` VARCHAR(100) NULL,
`abcd_vca_ssss_abc421` VARCHAR(100) NULL,
`abcd_vca_ssss_abc422` VARCHAR(100) NULL,
`abcd_vca_ssss_abc423` VARCHAR(100) NULL,
`abcd_vca_ssss_abc424` VARCHAR(100) NULL,
`abcd_vca_ssss_abc425` VARCHAR(100) NULL,
`abcd_vca_ssss_abc426` VARCHAR(100) NULL,
`abcd_vca_ssss_abc427` VARCHAR(100) NULL,
`abcd_vca_ssss_abc428` VARCHAR(100) NULL,
`abcd_vca_ssss_abc429` VARCHAR(100) NULL,
`abcd_vca_ssss_abc430` VARCHAR(100) NULL,
`abcd_vca_ssss_abc431` VARCHAR(100) NULL,
`abcd_vca_ssss_abc432` VARCHAR(100) NULL,
`abcd_vca_ssss_abc433` VARCHAR(100) NULL,
`abcd_vca_ssss_abc434` VARCHAR(100) NULL,
`abcd_vca_ssss_abc435` VARCHAR(100) NULL,
`abcd_vca_ssss_abc436` VARCHAR(100) NULL,
`abcd_vca_ssss_abc437` VARCHAR(100) NULL,
`abcd_vca_ssss_abc438` VARCHAR(100) NULL,
`abcd_vca_ssss_abc439` VARCHAR(100) NULL,
`abcd_vca_ssss_abc440` VARCHAR(100) NULL,
`abcd_vca_ssss_abc441` VARCHAR(100) NULL,
`abcd_vca_ssss_abc442` VARCHAR(100) NULL,
`abcd_vca_ssss_abc443` VARCHAR(100) NULL,
`abcd_vca_ssss_abc444` VARCHAR(100) NULL,
`abcd_vca_ssss_abc445` VARCHAR(100) NULL,
`abcd_vca_ssss_abc446` VARCHAR(100) NULL,
`abcd_vca_ssss_abc447` VARCHAR(100) NULL,
`abcd_vca_ssss_abc448` VARCHAR(100) NULL,
`abcd_vca_ssss_abc449` VARCHAR(100) NULL,
`abcd_vca_ssss_abc450` VARCHAR(100) NULL,
`abcd_vca_ssss_abc451` VARCHAR(100) NULL,
`abcd_vca_ssss_abc452` VARCHAR(100) NULL,
`abcd_vca_ssss_abc453` VARCHAR(100) NULL,
`abcd_vca_ssss_abc454` VARCHAR(100) NULL,
`abcd_vca_ssss_abc455` VARCHAR(100) NULL,
`abcd_vca_ssss_abc456` VARCHAR(100) NULL,
`abcd_vca_ssss_abc457` VARCHAR(100) NULL,
`abcd_vca_ssss_abc458` VARCHAR(100) NULL,
`abcd_vca_ssss_abc459` VARCHAR(100) NULL,
`abcd_vca_ssss_abc460` VARCHAR(100) NULL,
`abcd_vca_ssss_abc461` VARCHAR(100) NULL,
`abcd_vca_ssss_abc462` VARCHAR(100) NULL,
`abcd_vca_ssss_abc463` VARCHAR(100) NULL,
`abcd_vca_ssss_abc464` VARCHAR(100) NULL,
`abcd_vca_ssss_abc465` VARCHAR(100) NULL,
`abcd_vca_ssss_abc466` VARCHAR(100) NULL,
`abcd_vca_ssss_abc467` VARCHAR(100) NULL,
`abcd_vca_ssss_abc468` VARCHAR(100) NULL,
`abcd_vca_ssss_abc469` VARCHAR(100) NULL,
`abcd_vca_ssss_abc470` VARCHAR(100) NULL,
`abcd_vca_ssss_abc471` VARCHAR(100) NULL,
`abcd_vca_ssss_abc472` VARCHAR(100) NULL,
`abcd_vca_ssss_abc473` VARCHAR(100) NULL,
`abcd_vca_ssss_abc474` VARCHAR(100) NULL,
`abcd_vca_ssss_abc475` VARCHAR(100) NULL,
`abcd_vca_ssss_abc476` VARCHAR(100) NULL,
`abcd_vca_ssss_abc477` VARCHAR(100) NULL,
`abcd_vca_ssss_abc478` VARCHAR(100) NULL,
`abcd_vca_ssss_abc479` VARCHAR(100) NULL,
`abcd_vca_ssss_abc480` VARCHAR(100) NULL,
`abcd_vca_ssss_abc481` VARCHAR(100) NULL,
`abcd_vca_ssss_abc482` VARCHAR(100) NULL,
`abcd_vca_ssss_abc483` VARCHAR(100) NULL,
`abcd_vca_ssss_abc484` VARCHAR(100) NULL,
`abcd_vca_ssss_abc485` VARCHAR(100) NULL,
`abcd_vca_ssss_abc486` VARCHAR(100) NULL,
`abcd_vca_ssss_abc487` VARCHAR(100) NULL,
`abcd_vca_ssss_abc488` VARCHAR(100) NULL,
`abcd_vca_ssss_abc489` VARCHAR(100) NULL,
`abcd_vca_ssss_abc490` VARCHAR(100) NULL,
`abcd_vca_ssss_abc491` VARCHAR(100) NULL,
`abcd_vca_ssss_abc492` VARCHAR(100) NULL,
`abcd_vca_ssss_abc493` VARCHAR(100) NULL,
`abcd_vca_ssss_abc494` VARCHAR(100) NULL,
`abcd_vca_ssss_abc495` VARCHAR(100) NULL,
`abcd_vca_ssss_abc496` VARCHAR(100) NULL,
`abcd_vca_ssss_abc497` VARCHAR(100) NULL,
`abcd_vca_ssss_abc498` VARCHAR(100) NULL,
`abcd_vca_ssss_abc499` VARCHAR(100) NULL,
`abcd_vca_ssss_abc500` VARCHAR(100) NULL,
`abcd_vca_ssss_abc501` VARCHAR(100) NULL,
`abcd_vca_ssss_abc502` VARCHAR(100) NULL,
`abcd_vca_ssss_abc503` VARCHAR(100) NULL,
`abcd_vca_ssss_abc504` VARCHAR(100) NULL,
`abcd_vca_ssss_abc505` VARCHAR(100) NULL,
`abcd_vca_ssss_abc506` VARCHAR(100) NULL,
`abcd_vca_ssss_abc507` VARCHAR(100) NULL,
`abcd_vca_ssss_abc508` VARCHAR(100) NULL,
`abcd_vca_ssss_abc509` VARCHAR(100) NULL,
`abcd_vca_ssss_abc510` VARCHAR(100) NULL,
`abcd_vca_ssss_abc511` VARCHAR(100) NULL,
`abcd_vca_ssss_abc512` VARCHAR(100) NULL,
`abcd_vca_ssss_abc513` VARCHAR(100) NULL,
`abcd_vca_ssss_abc514` VARCHAR(100) NULL,
`abcd_vca_ssss_abc515` VARCHAR(100) NULL,
`abcd_vca_ssss_abc516` VARCHAR(100) NULL,
`abcd_vca_ssss_abc517` VARCHAR(100) NULL,
`abcd_vca_ssss_abc518` VARCHAR(100) NULL,
`abcd_vca_ssss_abc519` VARCHAR(100) NULL,
`abcd_vca_ssss_abc520` VARCHAR(100) NULL,
`abcd_vca_ssss_abc521` VARCHAR(100) NULL,
`abcd_vca_ssss_abc522` VARCHAR(100) NULL,
`abcd_vca_ssss_abc523` VARCHAR(100) NULL,
`abcd_vca_ssss_abc524` VARCHAR(100) NULL,
`abcd_vca_ssss_abc525` VARCHAR(100) NULL,
`abcd_vca_ssss_abc526` VARCHAR(100) NULL,
`abcd_vca_ssss_abc527` VARCHAR(100) NULL,
`abcd_vca_ssss_abc528` VARCHAR(100) NULL,
`abcd_vca_ssss_abc529` VARCHAR(100) NULL,
`abcd_vca_ssss_abc530` VARCHAR(100) NULL,
`abcd_vca_ssss_abc531` VARCHAR(100) NULL,
`abcd_vca_ssss_abc532` VARCHAR(100) NULL,
`abcd_vca_ssss_abc533` VARCHAR(100) NULL,
`abcd_vca_ssss_abc534` VARCHAR(100) NULL,
`abcd_vca_ssss_abc535` VARCHAR(100) NULL,
`abcd_vca_ssss_abc536` VARCHAR(100) NULL,
`abcd_vca_ssss_abc537` VARCHAR(100) NULL,
`abcd_vca_ssss_abc538` VARCHAR(100) NULL,
`abcd_vca_ssss_abc539` VARCHAR(100) NULL,
`abcd_vca_ssss_abc540` VARCHAR(100) NULL,
`abcd_vca_ssss_abc541` VARCHAR(100) NULL,
`abcd_vca_ssss_abc542` VARCHAR(100) NULL,
`abcd_vca_ssss_abc543` VARCHAR(100) NULL,
`abcd_vca_ssss_abc544` VARCHAR(100) NULL,
`abcd_vca_ssss_abc545` VARCHAR(100) NULL,
`abcd_vca_ssss_abc546` VARCHAR(100) NULL,
`abcd_vca_ssss_abc547` VARCHAR(100) NULL,
`abcd_vca_ssss_abc548` VARCHAR(100) NULL,
`abcd_vca_ssss_abc549` VARCHAR(100) NULL,
`abcd_vca_ssss_abc550` VARCHAR(100) NULL,
`abcd_vca_ssss_abc551` VARCHAR(100) NULL,
`abcd_vca_ssss_abc552` VARCHAR(100) NULL,
`abcd_vca_ssss_abc553` VARCHAR(100) NULL,
`abcd_vca_ssss_abc554` VARCHAR(100) NULL,
`abcd_vca_ssss_abc555` VARCHAR(100) NULL,
`abcd_vca_ssss_abc556` VARCHAR(100) NULL,
`abcd_vca_ssss_abc557` VARCHAR(100) NULL,
`abcd_vca_ssss_abc558` VARCHAR(100) NULL,
`abcd_vca_ssss_abc559` VARCHAR(100) NULL,
`abcd_vca_ssss_abc560` VARCHAR(100) NULL,
`abcd_vca_ssss_abc561` VARCHAR(100) NULL,
`abcd_vca_ssss_abc562` VARCHAR(100) NULL,
`abcd_vca_ssss_abc563` VARCHAR(100) NULL,
`abcd_vca_ssss_abc564` VARCHAR(100) NULL,
`abcd_vca_ssss_abc565` VARCHAR(100) NULL,
`abcd_vca_ssss_abc566` VARCHAR(100) NULL,
`abcd_vca_ssss_abc567` VARCHAR(100) NULL,
`abcd_vca_ssss_abc568` VARCHAR(100) NULL,
`abcd_vca_ssss_abc569` VARCHAR(100) NULL,
`abcd_vca_ssss_abc570` VARCHAR(100) NULL,
`abcd_vca_ssss_abc571` VARCHAR(100) NULL,
`abcd_vca_ssss_abc572` VARCHAR(100) NULL,
`abcd_vca_ssss_abc573` VARCHAR(100) NULL,
`abcd_vca_ssss_abc574` VARCHAR(100) NULL,
`abcd_vca_ssss_abc575` VARCHAR(100) NULL,
`abcd_vca_ssss_abc576` VARCHAR(100) NULL,
`abcd_vca_ssss_abc577` VARCHAR(100) NULL,
`abcd_vca_ssss_abc578` VARCHAR(100) NULL,
`abcd_vca_ssss_abc579` VARCHAR(100) NULL,
`abcd_vca_ssss_abc580` VARCHAR(100) NULL,
`abcd_vca_ssss_abc581` VARCHAR(100) NULL,
`abcd_vca_ssss_abc582` VARCHAR(100) NULL,
`abcd_vca_ssss_abc583` VARCHAR(100) NULL,
`abcd_vca_ssss_abc584` VARCHAR(100) NULL,
`abcd_vca_ssss_abc585` VARCHAR(100) NULL,
`abcd_vca_ssss_abc586` VARCHAR(100) NULL,
`abcd_vca_ssss_abc587` VARCHAR(100) NULL,
`abcd_vca_ssss_abc588` VARCHAR(100) NULL,
`abcd_vca_ssss_abc589` VARCHAR(100) NULL,
`abcd_vca_ssss_abc590` VARCHAR(100) NULL,
`abcd_vca_ssss_abc591` VARCHAR(100) NULL,
`abcd_vca_ssss_abc592` VARCHAR(100) NULL,
`abcd_vca_ssss_abc593` VARCHAR(100) NULL,
`abcd_vca_ssss_abc594` VARCHAR(100) NULL,
`abcd_vca_ssss_abc595` VARCHAR(100) NULL,
`abcd_vca_ssss_abc596` VARCHAR(100) NULL,
`abcd_vca_ssss_abc597` VARCHAR(100) NULL,
`abcd_vca_ssss_abc598` VARCHAR(100) NULL,
`abcd_vca_ssss_abc599` VARCHAR(100) NULL,
  PRIMARY KEY (`id`));
  • 메타트론 워크 벤치에서 t1 테이블 조회 시 오류
    image

문제 원인

  • #814 이슈를 진행하며 쿼리 애디터 결과를 복원하기 위한 메타 데이터를 메타트론 데이터 베이스 queryeditor_result 테이블에 저장하였음.
  • 워크 벤치에서 테이블 select 시 컬럼 갯수가 많은 경우(500개 이상) queryeditor_result 테이블 fields 컬럼의 저장 한계를 넘어서면서 발생하는 오류임
@Entity
@Table(name = "queryeditor_result")
public class QueryEditorResult {
  // ...
  @Column(name = "fields", length = 65535, columnDefinition = "TEXT")
  @JsonRawValue
  @JsonDeserialize(using = KeepAsJsonDeserialzier.class)
  private String fields;
  
}

YooYoungmo added a commit to YooYoungmo/metatron-discovery that referenced this issue Jan 10, 2019

@YooYoungmo

This comment has been minimized.

Copy link
Collaborator

YooYoungmo commented Jan 10, 2019

@Taehui 이 건 수정은 기존 데이터베이스 테이블 컬럼 데이터 타입을 변경하는 것입니다. Hibernate 스키마 자동 생성 기능 특징 상 이미 존재하는 테이블 컬럼의 경우 자동으로 반영해 주지 않습니다.
(#963 (comment) 와 같은 문제 입니다.)

따라서 아래 SQL을 실행해 주셔야 합니다.

ALTER TABLE `queryeditor_result` 
CHANGE COLUMN `fields` `fields` LONGTEXT NULL DEFAULT NULL ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment