To Rajat Khandelwal: I checked some of fact/dimtable list partitions command, results:
lens-shell>dimtable list partitions product_table local fullPartitionSpec : partSpecElement : key : dt value : 2014-03-27-12 key : category value : Clothes partitionParameters : property : name : numFiles value : 0 name : COLUMN_STATS_ACCURATE value : false name : transient_lastDdlTime value : 1440130580 name : numRows value : -1 name : totalSize value : 0 name : cube.storagetable.partition.update.period value : HOURLY name : rawDataSize value : -1 lens-shell>fact list partitions --fact_name sales_aggr_fact2 --storage_name mydb fullPartitionSpec : partSpecElement : key : pt value : 2015-04-13 key : ot value : 2015-04-12 key : dt value : 2015-04-12 partitionParameters : property : name : numFiles value : 0 name : COLUMN_STATS_ACCURATE value : false name : transient_lastDdlTime value : 1440130618 name : numRows value : -1 name : totalSize value : 0 name : cube.storagetable.partition.update.period value : DAILY name : rawDataSize value : -1 serdeParameters : name : anotherdb@mydb_sales_aggr_fact2@pt=2015-04-13/ot=2015-04-12/dt=2015-04-12 location : file:/tmp/examples/data/sales_aggr_fact2_local2 inputFormat : org.apache.hadoop.mapred.TextInputFormat outputFormat : org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serdeClassname : org.apache.lens.storage.db.DBSerde updatePeriod : DAILY发件人: Rajat Khandelwal [mailto:[email protected]] 发送时间: 2015年8月24日 13:00 收件人: [email protected] 主题: Re: a qusetion about run lens example Hi Can you check if partitions have been added by doing fact list partitions and dimtable list partitions. On Mon, Aug 24, 2015, 08:18 Wangchangchun (A) <[email protected]<mailto:[email protected]>> wrote: Hello, I try to run the example which is showed in “showterm.io<http://showterm.io>”. Now “create storage, create dimension, create cube, create dimtable,create fact, dimtable add partitions, dimtable add single-partition, fact add partitions” is ok, but execute “query execute” have no result. I found that in city_table.xml, table_location defined as “/tmp/examples/city”, While /tmp/examples/city/examples/data/city_local is empty, There is no “city-local.data”, is it a problem? Can someone help me to answer this question?
