Hi >From a quick diagnosis, you've most probably forgotten to change paths to absolute paths in the partition files. https://gist.github.com/prongs/0d8ab2af9d50532eaad8#file-lens_demo_commands-L24. Partitions are supposed to be added only after this is done.
On Mon, Aug 24, 2015 at 12:35 PM Wangchangchun (A) < [email protected]> wrote: > 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]> > wrote: > > Hello, I try to run the example which is showed in “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? > >
