search

cloudera / hue

Open source SQL Query Assistant service for Databases/Warehouses
https://cloudera.com
Apache License 2.0
1.17k stars 367 forks source link

The file size become 64MB after I use 'create a new table from file' in Hue->Data Browser->metastore manager. #167

Closed p1o2p3u1 closed 9 years ago

p1o2p3u1 commented 9 years ago

I have a test cluster with 3 nodes and enough drive space. I have a 5GB csv file stored in hdfs. I want to create a hive table with Hue->Data Browser->Metastore Manager->create table from file. Everything works fine until I checked out the db file in /user/hive/warehouse/mydatabase and notice that the file size become 64MB. Is that a bug?

Here is the log output from Hue

15/03/26 06:20:33 INFO log.PerfLogger: <PERFLOG method=compile from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:33 INFO log.PerfLogger: <PERFLOG method=parse from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:33 INFO parse.ParseDriver: Parsing command: CREATE TABLE `default.test2`
(
  `AREAKEY` int ,
  `LON` float ,
  `LAT` float ,
  `BLOCK` bigint ,
  `BLKGRP` bigint ,
  `AREALAND` float ,
  `AREAWATER` float ,
  `STUSAB` string ,
  `STATECE` tinyint ,
  `STATE` tinyint ,
  `STNAME` string ,
  `REGION` tinyint ,
  `DIVISION` tinyint ,
  `COUNTY` smallint ,
  `CNTYNAM` string ,
  `MACODE` smallint ,
  `MANAME` string ,
  `ZIP_CODE` int ,
  `PONAME` string ,
  `CITYNAME` string ,
  `CITYCODE` int ,
  `CBSANAME` string ,
  `CBSACODE` smallint ,
  `CBSATYPE` bigint ,
  `AREACODE` smallint ,
  `ACSTTPOP0` smallint ,
  `ACSAGE4Y0` tinyint ,
  `ACSAGE17Y0` tinyint ,
  `ACSAGE59` tinyint ,
  `ACSAGE1014` tinyint ,
  `ACSAGE1519` tinyint ,
  `ACSAGE2024` tinyint ,
  `ACSAGE34Y0` tinyint ,
  `ACSAGE44Y0` tinyint ,
  `ACSAGE54Y0` tinyint ,
  `ACSAGE64Y0` tinyint ,
  `ACSAGE65Y0` tinyint ,
  `ACSMALES` smallint ,
  `ACSFEMALES` smallint ,
  `POPHH0` smallint ,
  `FAMHH0` smallint ,
  `NONFAM0` tinyint ,
  `GRPQRT0` tinyint ,
  `MARSTAT0` smallint ,
  `NEVMAR0` smallint ,
  `MARRIED0` tinyint ,
  `WIDOW0` tinyint ,
  `DIVORC0` tinyint ,
  `RACE0` smallint ,
  `WHITE0` tinyint ,
  `BLACK0` tinyint ,
  `AMIND0` bigint ,
  `ASIAN0` tinyint ,
  `HAWAII0` bigint ,
  `OTHRACE0` smallint ,
  `TWORACES0` bigint ,
  `HISPAN0` smallint ,
  `WHNOHSP0` tinyint ,
  `TOTHH0` tinyint ,
  `FMHH0` tinyint ,
  `MARKID0` tinyint ,
  `MKID0` tinyint ,
  `FKID0` tinyint ,
  `NOFMHH0` tinyint ,
  `SINGLE0` tinyint ,
  `EDUCAT0` smallint ,
  `TT8GR0` tinyint ,
  `TT12GR0` tinyint ,
  `TTHS0` tinyint ,
  `TTSMCOL0` tinyint ,
  `TTASSOC0` tinyint ,
  `TTBACH0` tinyint ,
  `TTGRAD0` bigint ,
  `EMPLOY0` string ,
  `MARMFRC0` bigint ,
  `MEMPLOY0` bigint ,
  `MUNEMPL0` bigint ,
  `MNOWORK0` bigint ,
  `FARMFRC0` bigint ,
  `FEMPLOY0` bigint ,
  `FUNEMPL0` bigint ,
  `FNOWORK0` bigint ,
  `HHINCOM0` tinyint ,
  `INC10HH0` tinyint ,
  `INC15HH0` tinyint ,
  `INC20HH0` tinyint ,
  `INC25HH0` tinyint ,
  `INC30HH0` tinyint ,
  `INC35HH0` bigint ,
  `INC40HH0` bigint ,
  `INC45HH0` bigint ,
  `INC50HH0` tinyint ,
  `INC60HH0` tinyint ,
  `INC75HH0` tinyint ,
  `INC100HH0` bigint ,
  `INC125HH0` tinyint ,
  `INC150HH0` bigint ,
  `INC200HH0` bigint ,
  `INC201HH0` bigint ,
  `MEDHHIN0` smallint ,
  `AGGHHIN0` int ,
  `PCAPIN0` smallint ,
  `MDFAMIN0` smallint ,
  `ACSTOTHU` tinyint ,
  `ACSOWOCHU0` tinyint ,
  `ACSRNOCHU0` tinyint ,
  `ACSVACHU0` tinyint ,
  `ACSAVGHHSZ` float ,
  `ACSAVGSZOWN` float ,
  `ACSAVGSZRNT` float ,
  `UNITS0` tinyint ,
  `UNIT1D0` tinyint ,
  `UNIT1AT0` tinyint ,
  `UNIT4S0` tinyint ,
  `UNIT19S0` tinyint ,
  `UNIT20S0` bigint ,
  `MBLRVVN0` bigint ,
  `MDYRBLT0` smallint ,
  `VALOWNR0` tinyint ,
  `H30VAL0` bigint ,
  `H60VAL0` bigint ,
  `H100VAL0` bigint ,
  `H200VAL0` bigint ,
  `H300VAL0` tinyint ,
  `H500VAL0` tinyint ,
  `H501VAL0` tinyint ,
  `MEDVALO0` int ,
  `AGGVALO0` bigint ,
  `GROSSRNT0` tinyint ,
  `G200RNT0` bigint ,
  `G300RNT0` bigint ,
  `G500RNT0` bigint ,
  `G750RNT0` tinyint ,
  `G1000RNT0` tinyint ,
  `G1001RNT0` tinyint ,
  `NORENT0` bigint ,
  `MDGRSRN0` smallint ,
  `eSTOTPOP` smallint ,
  `eSTOTCNPOP` smallint ,
  `eSPOPCHPCT` float ,
  `eSPOPDENS` float ,
  `eSPOP0_5` smallint ,
  `eSPOP6_17` smallint ,
  `eSPOP0_4` smallint ,
  `eSPOP5_9` smallint ,
  `eSPOP10_14` tinyint ,
  `eSPOP15_19` tinyint ,
  `eSPOP20_24` tinyint ,
  `eSPOP25_29` tinyint ,
  `eSPOP30_34` tinyint ,
  `eSPOP35_39` tinyint ,
  `eSPOP40_44` tinyint ,
  `eSPOP45_49` tinyint ,
  `eSPOP50_54` tinyint ,
  `eSPOP55_59` tinyint ,
  `eSPOP60_64` tinyint ,
  `eSPOP65_69` tinyint ,
  `eSPOP70_74` tinyint ,
  `eSPOP75_79` tinyint ,
  `eSPOP80_84` tinyint ,
  `eSPOP85P` tinyint ,
  `eSMEDAGE` float ,
  `eSPOPWA` smallint ,
  `eSPOPBA` smallint ,
  `eSPOPNA` tinyint ,
  `eSPOPAA` bigint ,
  `eSPOPPA` bigint ,
  `eSPOPR2` smallint ,
  `eSPOPHS` smallint ,
  `eSPOPWN` tinyint ,
  `eSTOTMALES` smallint ,
  `eSTOTFEMAL` smallint ,
  `eSPOPWAM` smallint ,
  `eSPOPBAM` tinyint ,
  `eSPOPNAM` tinyint ,
  `eSPOPAAM` bigint ,
  `eSPOPPAM` bigint ,
  `eSPOPR2M` smallint ,
  `eSPOPHSM` smallint ,
  `eSPOPWNM` bigint ,
  `eSPOPWAF` smallint ,
  `eSPOPBAF` tinyint ,
  `eSPOPNAF` tinyint ,
  `eSPOPAAF` bigint ,
  `eSPOPPAF` bigint ,
  `eSPOPR2F` smallint ,
  `eSPOPHSF` smallint ,
  `eSPOPWNF` tinyint ,
  `eSPOPGRQ` tinyint ,
  `eSTOTHH` smallint ,
  `eSTOTCNSHH` smallint ,
  `eSHHCHGE` float ,
  `eSAVGHHSZE` float ,
  `eSONEPRSHH` tinyint ,
  `eSTOTFAM` smallint ,
  `eSTOTHU` smallint ,
  `eSHUOWNER` tinyint ,
  `eSHURENTER` smallint ,
  `eSHUVACANT` tinyint ,
  `eSHUNDR10K` tinyint ,
  `eSH10_15` tinyint ,
  `eSH15_20` tinyint ,
  `eSH20_25` tinyint ,
  `eSH25_30` bigint ,
  `eSH30_35` tinyint ,
  `eSH35_40` tinyint ,
  `eSH40_45` tinyint ,
  `eSH45_50` tinyint ,
  `eSH50_60` tinyint ,
  `eSH60_75` tinyint ,
  `eSH75_100` tinyint ,
  `eSH100_125` bigint ,
  `eSH125_150` tinyint ,
  `eSH150_200` bigint ,
  `eSH200KP` bigint ,
  `eSHMEDINC` smallint ,
  `eSHAGGINC` int ,
  `eSHAVGINC` smallint ,
  `eSPERCPINC` smallint ,
  `pSTOTPOP` smallint ,
  `pSTOTCNPOP` smallint ,
  `pSPOPCHPCT` float ,
  `pSPOPDENS` float ,
  `pSPOP0_5` smallint ,
  `pSPOP6_17` smallint ,
  `pSPOP0_4` smallint ,
  `pSPOP5_9` smallint ,
  `pSPOP10_14` smallint ,
  `pSPOP15_19` tinyint ,
  `pSPOP20_24` tinyint ,
  `pSPOP25_29` tinyint ,
  `pSPOP30_34` tinyint ,
  `pSPOP35_39` tinyint ,
  `pSPOP40_44` tinyint ,
  `pSPOP45_49` tinyint ,
  `pSPOP50_54` tinyint ,
  `pSPOP55_59` tinyint ,
  `pSPOP60_64` tinyint ,
  `pSPOP65_69` tinyint ,
  `pSPOP70_74` tinyint ,
  `pSPOP75_79` tinyint ,
  `pSPOP80_84` tinyint ,
  `pSPOP85P` tinyint ,
  `pSMEDAGE` float ,
  `pSPOPWA` smallint ,
  `pSPOPBA` smallint ,
  `pSPOPNA` bigint ,
  `pSPOPAA` bigint ,
  `pSPOPPA` bigint ,
  `pSPOPR2` smallint ,
  `pSPOPHS` smallint ,
  `pSPOPWN` tinyint ,
  `pSTOTMALES` smallint ,
  `pSTOTFEMAL` smallint ,
  `pSPOPWAM` smallint ,
  `pSPOPBAM` tinyint ,
  `pSPOPNAM` bigint ,
  `pSPOPAAM` bigint ,
  `pSPOPPAM` bigint ,
  `pSPOPR2M` smallint ,
  `pSPOPHSM` smallint ,
  `pSPOPWNM` bigint ,
  `pSPOPWAF` smallint ,
  `pSPOPBAF` tinyint ,
  `pSPOPNAF` bigint ,
  `pSPOPAAF` bigint ,
  `pSPOPPAF` bigint ,
  `pSPOPR2F` smallint ,
  `pSPOPHSF` smallint ,
  `pSPOPWNF` tinyint ,
  `pSPOPGRQ` tinyint ,
  `pSTOTHH` smallint ,
  `pSTOTCNSHH` smallint ,
  `pSHHCHGE` float ,
  `pSAVGHHSZE` float ,
  `pSONEPRSHH` tinyint ,
  `pSTOTFAM` smallint ,
  `pSTOTHU` smallint ,
  `pSHUOWNER` tinyint ,
  `pSHURENTER` smallint ,
  `pSHUVACANT` tinyint ,
  `pSHUNDR10K` tinyint ,
  `pSH10_15` tinyint ,
  `pSH15_20` tinyint ,
  `pSH20_25` tinyint ,
  `pSH25_30` bigint ,
  `pSH30_35` tinyint ,
  `pSH35_40` tinyint ,
  `pSH40_45` tinyint ,
  `pSH45_50` tinyint ,
  `pSH50_60` tinyint ,
  `pSH60_75` tinyint ,
  `pSH75_100` tinyint ,
  `pSH100_125` bigint ,
  `pSH125_150` tinyint ,
  `pSH150_200` bigint ,
  `pSH200KP` bigint ,
  `pSHMEDINC` smallint ,
  `pSHAGGINC` int ,
  `pSHAVGINC` smallint ,
  `pSPERCPINC` smallint ) 
ROW FORMAT   DELIMITED
    FIELDS TERMINATED BY ','
15/03/26 06:20:34 INFO parse.ParseDriver: Parse Completed
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=parse start=1427322033984 end=1427322034036 duration=52 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: <PERFLOG method=semanticAnalyze from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO parse.SemanticAnalyzer: Starting Semantic Analysis
15/03/26 06:20:34 INFO parse.SemanticAnalyzer: Creating table default.test2 position=13
15/03/26 06:20:34 INFO ql.Driver: Semantic Analysis Completed
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=semanticAnalyze start=1427322034036 end=1427322034053 duration=17 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:null, properties:null)
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=compile start=1427322033983 end=1427322034054 duration=71 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: <PERFLOG method=Driver.run from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: <PERFLOG method=TimeToSubmit from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: <PERFLOG method=acquireReadWriteLocks from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO lockmgr.DummyTxnManager: Creating lock manager of type org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveLockManager
15/03/26 06:20:34 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=n2.ccntgrid.zju.edu:2181,n0.ccntgrid.zju.edu:2181,n1.ccntgrid.zju.edu:2181 sessionTimeout=600000 watcher=org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveLockManager$DummyWatcher@4add054a
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=acquireReadWriteLocks start=1427322034061 end=1427322034091 duration=30 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: <PERFLOG method=Driver.execute from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO ql.Driver: Starting command: CREATE TABLE `default.test2`
(
  `AREAKEY` int ,
  `LON` float ,
  `LAT` float ,
  `BLOCK` bigint ,
  `BLKGRP` bigint ,
  `AREALAND` float ,
  `AREAWATER` float ,
  `STUSAB` string ,
  `STATECE` tinyint ,
  `STATE` tinyint ,
  `STNAME` string ,
  `REGION` tinyint ,
  `DIVISION` tinyint ,
  `COUNTY` smallint ,
  `CNTYNAM` string ,
  `MACODE` smallint ,
  `MANAME` string ,
  `ZIP_CODE` int ,
  `PONAME` string ,
  `CITYNAME` string ,
  `CITYCODE` int ,
  `CBSANAME` string ,
  `CBSACODE` smallint ,
  `CBSATYPE` bigint ,
  `AREACODE` smallint ,
  `ACSTTPOP0` smallint ,
  `ACSAGE4Y0` tinyint ,
  `ACSAGE17Y0` tinyint ,
  `ACSAGE59` tinyint ,
  `ACSAGE1014` tinyint ,
  `ACSAGE1519` tinyint ,
  `ACSAGE2024` tinyint ,
  `ACSAGE34Y0` tinyint ,
  `ACSAGE44Y0` tinyint ,
  `ACSAGE54Y0` tinyint ,
  `ACSAGE64Y0` tinyint ,
  `ACSAGE65Y0` tinyint ,
  `ACSMALES` smallint ,
  `ACSFEMALES` smallint ,
  `POPHH0` smallint ,
  `FAMHH0` smallint ,
  `NONFAM0` tinyint ,
  `GRPQRT0` tinyint ,
  `MARSTAT0` smallint ,
  `NEVMAR0` smallint ,
  `MARRIED0` tinyint ,
  `WIDOW0` tinyint ,
  `DIVORC0` tinyint ,
  `RACE0` smallint ,
  `WHITE0` tinyint ,
  `BLACK0` tinyint ,
  `AMIND0` bigint ,
  `ASIAN0` tinyint ,
  `HAWAII0` bigint ,
  `OTHRACE0` smallint ,
  `TWORACES0` bigint ,
  `HISPAN0` smallint ,
  `WHNOHSP0` tinyint ,
  `TOTHH0` tinyint ,
  `FMHH0` tinyint ,
  `MARKID0` tinyint ,
  `MKID0` tinyint ,
  `FKID0` tinyint ,
  `NOFMHH0` tinyint ,
  `SINGLE0` tinyint ,
  `EDUCAT0` smallint ,
  `TT8GR0` tinyint ,
  `TT12GR0` tinyint ,
  `TTHS0` tinyint ,
  `TTSMCOL0` tinyint ,
  `TTASSOC0` tinyint ,
  `TTBACH0` tinyint ,
  `TTGRAD0` bigint ,
  `EMPLOY0` string ,
  `MARMFRC0` bigint ,
  `MEMPLOY0` bigint ,
  `MUNEMPL0` bigint ,
  `MNOWORK0` bigint ,
  `FARMFRC0` bigint ,
  `FEMPLOY0` bigint ,
  `FUNEMPL0` bigint ,
  `FNOWORK0` bigint ,
  `HHINCOM0` tinyint ,
  `INC10HH0` tinyint ,
  `INC15HH0` tinyint ,
  `INC20HH0` tinyint ,
  `INC25HH0` tinyint ,
  `INC30HH0` tinyint ,
  `INC35HH0` bigint ,
  `INC40HH0` bigint ,
  `INC45HH0` bigint ,
  `INC50HH0` tinyint ,
  `INC60HH0` tinyint ,
  `INC75HH0` tinyint ,
  `INC100HH0` bigint ,
  `INC125HH0` tinyint ,
  `INC150HH0` bigint ,
  `INC200HH0` bigint ,
  `INC201HH0` bigint ,
  `MEDHHIN0` smallint ,
  `AGGHHIN0` int ,
  `PCAPIN0` smallint ,
  `MDFAMIN0` smallint ,
  `ACSTOTHU` tinyint ,
  `ACSOWOCHU0` tinyint ,
  `ACSRNOCHU0` tinyint ,
  `ACSVACHU0` tinyint ,
  `ACSAVGHHSZ` float ,
  `ACSAVGSZOWN` float ,
  `ACSAVGSZRNT` float ,
  `UNITS0` tinyint ,
  `UNIT1D0` tinyint ,
  `UNIT1AT0` tinyint ,
  `UNIT4S0` tinyint ,
  `UNIT19S0` tinyint ,
  `UNIT20S0` bigint ,
  `MBLRVVN0` bigint ,
  `MDYRBLT0` smallint ,
  `VALOWNR0` tinyint ,
  `H30VAL0` bigint ,
  `H60VAL0` bigint ,
  `H100VAL0` bigint ,
  `H200VAL0` bigint ,
  `H300VAL0` tinyint ,
  `H500VAL0` tinyint ,
  `H501VAL0` tinyint ,
  `MEDVALO0` int ,
  `AGGVALO0` bigint ,
  `GROSSRNT0` tinyint ,
  `G200RNT0` bigint ,
  `G300RNT0` bigint ,
  `G500RNT0` bigint ,
  `G750RNT0` tinyint ,
  `G1000RNT0` tinyint ,
  `G1001RNT0` tinyint ,
  `NORENT0` bigint ,
  `MDGRSRN0` smallint ,
  `eSTOTPOP` smallint ,
  `eSTOTCNPOP` smallint ,
  `eSPOPCHPCT` float ,
  `eSPOPDENS` float ,
  `eSPOP0_5` smallint ,
  `eSPOP6_17` smallint ,
  `eSPOP0_4` smallint ,
  `eSPOP5_9` smallint ,
  `eSPOP10_14` tinyint ,
  `eSPOP15_19` tinyint ,
  `eSPOP20_24` tinyint ,
  `eSPOP25_29` tinyint ,
  `eSPOP30_34` tinyint ,
  `eSPOP35_39` tinyint ,
  `eSPOP40_44` tinyint ,
  `eSPOP45_49` tinyint ,
  `eSPOP50_54` tinyint ,
  `eSPOP55_59` tinyint ,
  `eSPOP60_64` tinyint ,
  `eSPOP65_69` tinyint ,
  `eSPOP70_74` tinyint ,
  `eSPOP75_79` tinyint ,
  `eSPOP80_84` tinyint ,
  `eSPOP85P` tinyint ,
  `eSMEDAGE` float ,
  `eSPOPWA` smallint ,
  `eSPOPBA` smallint ,
  `eSPOPNA` tinyint ,
  `eSPOPAA` bigint ,
  `eSPOPPA` bigint ,
  `eSPOPR2` smallint ,
  `eSPOPHS` smallint ,
  `eSPOPWN` tinyint ,
  `eSTOTMALES` smallint ,
  `eSTOTFEMAL` smallint ,
  `eSPOPWAM` smallint ,
  `eSPOPBAM` tinyint ,
  `eSPOPNAM` tinyint ,
  `eSPOPAAM` bigint ,
  `eSPOPPAM` bigint ,
  `eSPOPR2M` smallint ,
  `eSPOPHSM` smallint ,
  `eSPOPWNM` bigint ,
  `eSPOPWAF` smallint ,
  `eSPOPBAF` tinyint ,
  `eSPOPNAF` tinyint ,
  `eSPOPAAF` bigint ,
  `eSPOPPAF` bigint ,
  `eSPOPR2F` smallint ,
  `eSPOPHSF` smallint ,
  `eSPOPWNF` tinyint ,
  `eSPOPGRQ` tinyint ,
  `eSTOTHH` smallint ,
  `eSTOTCNSHH` smallint ,
  `eSHHCHGE` float ,
  `eSAVGHHSZE` float ,
  `eSONEPRSHH` tinyint ,
  `eSTOTFAM` smallint ,
  `eSTOTHU` smallint ,
  `eSHUOWNER` tinyint ,
  `eSHURENTER` smallint ,
  `eSHUVACANT` tinyint ,
  `eSHUNDR10K` tinyint ,
  `eSH10_15` tinyint ,
  `eSH15_20` tinyint ,
  `eSH20_25` tinyint ,
  `eSH25_30` bigint ,
  `eSH30_35` tinyint ,
  `eSH35_40` tinyint ,
  `eSH40_45` tinyint ,
  `eSH45_50` tinyint ,
  `eSH50_60` tinyint ,
  `eSH60_75` tinyint ,
  `eSH75_100` tinyint ,
  `eSH100_125` bigint ,
  `eSH125_150` tinyint ,
  `eSH150_200` bigint ,
  `eSH200KP` bigint ,
  `eSHMEDINC` smallint ,
  `eSHAGGINC` int ,
  `eSHAVGINC` smallint ,
  `eSPERCPINC` smallint ,
  `pSTOTPOP` smallint ,
  `pSTOTCNPOP` smallint ,
  `pSPOPCHPCT` float ,
  `pSPOPDENS` float ,
  `pSPOP0_5` smallint ,
  `pSPOP6_17` smallint ,
  `pSPOP0_4` smallint ,
  `pSPOP5_9` smallint ,
  `pSPOP10_14` smallint ,
  `pSPOP15_19` tinyint ,
  `pSPOP20_24` tinyint ,
  `pSPOP25_29` tinyint ,
  `pSPOP30_34` tinyint ,
  `pSPOP35_39` tinyint ,
  `pSPOP40_44` tinyint ,
  `pSPOP45_49` tinyint ,
  `pSPOP50_54` tinyint ,
  `pSPOP55_59` tinyint ,
  `pSPOP60_64` tinyint ,
  `pSPOP65_69` tinyint ,
  `pSPOP70_74` tinyint ,
  `pSPOP75_79` tinyint ,
  `pSPOP80_84` tinyint ,
  `pSPOP85P` tinyint ,
  `pSMEDAGE` float ,
  `pSPOPWA` smallint ,
  `pSPOPBA` smallint ,
  `pSPOPNA` bigint ,
  `pSPOPAA` bigint ,
  `pSPOPPA` bigint ,
  `pSPOPR2` smallint ,
  `pSPOPHS` smallint ,
  `pSPOPWN` tinyint ,
  `pSTOTMALES` smallint ,
  `pSTOTFEMAL` smallint ,
  `pSPOPWAM` smallint ,
  `pSPOPBAM` tinyint ,
  `pSPOPNAM` bigint ,
  `pSPOPAAM` bigint ,
  `pSPOPPAM` bigint ,
  `pSPOPR2M` smallint ,
  `pSPOPHSM` smallint ,
  `pSPOPWNM` bigint ,
  `pSPOPWAF` smallint ,
  `pSPOPBAF` tinyint ,
  `pSPOPNAF` bigint ,
  `pSPOPAAF` bigint ,
  `pSPOPPAF` bigint ,
  `pSPOPR2F` smallint ,
  `pSPOPHSF` smallint ,
  `pSPOPWNF` tinyint ,
  `pSPOPGRQ` tinyint ,
  `pSTOTHH` smallint ,
  `pSTOTCNSHH` smallint ,
  `pSHHCHGE` float ,
  `pSAVGHHSZE` float ,
  `pSONEPRSHH` tinyint ,
  `pSTOTFAM` smallint ,
  `pSTOTHU` smallint ,
  `pSHUOWNER` tinyint ,
  `pSHURENTER` smallint ,
  `pSHUVACANT` tinyint ,
  `pSHUNDR10K` tinyint ,
  `pSH10_15` tinyint ,
  `pSH15_20` tinyint ,
  `pSH20_25` tinyint ,
  `pSH25_30` bigint ,
  `pSH30_35` tinyint ,
  `pSH35_40` tinyint ,
  `pSH40_45` tinyint ,
  `pSH45_50` tinyint ,
  `pSH50_60` tinyint ,
  `pSH60_75` tinyint ,
  `pSH75_100` tinyint ,
  `pSH100_125` bigint ,
  `pSH125_150` tinyint ,
  `pSH150_200` bigint ,
  `pSH200KP` bigint ,
  `pSHMEDINC` smallint ,
  `pSHAGGINC` int ,
  `pSHAVGINC` smallint ,
  `pSPERCPINC` smallint ) 
ROW FORMAT   DELIMITED
    FIELDS TERMINATED BY ','
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=TimeToSubmit start=1427322034060 end=1427322034092 duration=32 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: <PERFLOG method=runTasks from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: <PERFLOG method=task.DDL.Stage-0 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=runTasks start=1427322034092 end=1427322034587 duration=495 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: <PERFLOG method=PostHook.com.cloudera.navigator.audit.hive.HiveExecHookContext from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=PostHook.com.cloudera.navigator.audit.hive.HiveExecHookContext start=1427322034588 end=1427322034617 duration=29 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=Driver.execute start=1427322034091 end=1427322034617 duration=526 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO ql.Driver: OK
15/03/26 06:20:34 INFO log.PerfLogger: <PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO ZooKeeperHiveLockManager:  about to release lock for default
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=releaseLocks start=1427322034619 end=1427322034648 duration=29 from=org.apache.hadoop.hive.ql.Driver>
15/03/26 06:20:34 INFO log.PerfLogger: </PERFLOG method=Driver.run start=1427322034057 end=1427322034648 duration=591 from=org.apache.hadoop.hive.ql.Driver>

My CDH version is 5.2.0, Hue is 3.6.0.

romainr commented 9 years ago

This is https://issues.cloudera.org/browse/HUE-2501 which I think is in C5.3.2 or at least for sure in the upcoming C5.4