正在查询的表：

describe formatted hfe_reference.dim_number;

详细信息：

col_name    data_type   comment

# col_name              data_type               comment

number  int Format: <integer> | Example: 0 | Description: Ascending number series

# Detailed Table Information    NULL    NULL

Database:               hfe_reference           NULL
Owner:                  admin                   NULL
CreateTime:             Tue Mar 20 04:19:39 UTC 2018    NULL
LastAccessTime:         UNKNOWN                 NULL
Protect Mode:           None                    NULL
Retention:              0   NULL
Location:               xxxxxxxxx   NULL
Table Type:             MANAGED_TABLE           NULL
Table Parameters:   NULL    NULL
    SORTBUCKETCOLSPREFIX    TRUE                
    auto.purge              true                
    comment                 Holds a number series that can be used to join onto for calculations
    immutable               true                
    numFiles                5
    orc.bloom.filter.columns    number              
    orc.bloom.filter.fpp    0.05
    orc.compress            SNAPPY              
    orc.compress.size       262144
    orc.create.index        true                
    orc.row.index.stride    500000
    orc.stripe.size         67108864
    tag_created_by          xxxxxxx
    tag_created_date        3/03/2018
    tag_release_environment xxxxxxx
    tag_release_modified_by xxxxxxx
    tag_release_timestamp   18:46.5
    totalSize               884634582
    transient_lastDdlTime   1522819180
    NULL    NULL

# Storage Information   NULL    NULL

SerDe Library:          org.apache.hadoop.hive.ql.io.orc.OrcSerde   NULL
InputFormat:            org.apache.hadoop.hive.ql.io.orc.OrcInputFormat NULL
OutputFormat:           org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat    NULL
Compressed:             No                      NULL
Num Buckets:            1   NULL
Bucket Columns:         [number]                NULL
Sort Columns:           [Order(col:number, order:1)]    NULL
Storage Desc Params:    NULL    NULL
    serialization.format    1

这样做有效：

select number from hfe_reference.dim_number limit 10;

这不会导致查询运行，而是一个空结果：

select number from hfe_reference.dim_number where number < 5;

其他 WHERE 已使用子句，例如。 where number = 2 , where number between 0 and 5 为什么where子句导致结果集为空？