[GitHub] [incubator-dolphinscheduler] felix-thinkingdata commented on issue #3739: [Bug][service] sql result set is converted to json, there is data loss

[GitBox <gi...@apache.org>]

felix-thinkingdata commented on issue #3739:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3739#issuecomment-692084262


   select DBS.NAME                                                        as 'DB_NAME',
          PARTITIONS.PART_ID,
          TBLS.TBL_NAME,
          PARTITIONS.PART_NAME,
          SDS.LOCATION,
          PARTITION_FILENUM.PARAM_VALUE                                   AS FILE_NUM,
          PARTITION_TOTAL_Size.PARAM_VALUE                                AS FILE_SIZE,
          CEILING(PARTITION_TOTAL_Size.PARAM_VALUE / (128 * 1024 * 1024)) AS CLAC_FILE_NUM
   from DBS,
        SDS,
        TBLS,
        PARTITIONS,
        (select * from PARTITION_PARAMS where PARAM_KEY = 'numFiles') as PARTITION_FILENUM,
        (select * from PARTITION_PARAMS where PARAM_KEY = 'totalSize') as PARTITION_TOTAL_Size
   where DBS.DB_ID = TBLS.DB_ID
     and PARTITIONS.SD_ID = SDS.SD_ID
     and TBLS.TBL_ID = PARTITIONS.TBL_ID
     and PARTITIONS.PART_ID = PARTITION_FILENUM.PART_ID
     and PARTITIONS.PART_ID = PARTITION_TOTAL_Size.PART_ID
     AND PARTITION_FILENUM.PARAM_VALUE > CEILING(PARTITION_TOTAL_Size.PARAM_VALUE / (128 * 1024 * 1024))
   limit 1
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org