Hi all,
I have following structure of partitions for my fastbit data :
/var/fbdata/YYYY/MM/DD/HH/MM/ which includes (SRC_IP,IN_BYTES,DST_IP,. ) +
metaTags = year=YYYY,month=MM,day=DD,hour=HH
1 - This query is OK : ibis -d /var/fbdata -q "select SUM(IN_BYTES) where
year='2012'" // or any other conditions like 1=1 IN_BYTES>0 ..
2- This query gives me error : : ibis -d /var/fbdata -q "select
SUM(IN_BYTES) " ( fails with msg : tableSelect:: select(sum(in_bytes), ) failed
on table T-00 )
Seams we have to set a where condition anyway
3- This query is ok : ibis -d /var/fbdata/2012/02/06/11 -q "select
hour,sum(in_bytes) where year='2012'" -v=4
Result :
"11", 307445
I repeat the same query with ../06/12 , .06/13, .. ( all partitions inside day
06 one by one) and I get correct result.
Now ! when I try to do the same query on all hour partions for one day ( 06) ,
here is my try result :
4- This query gives me error : ibis -d /var/fbdata/2012/02/06 -q "select
hour,sum(in_bytes) where year='2012'" -v=4
Message :
Warning -- filter::sift2S(SELECT hour,sum(in_bytes) FROM 56 data partitions
WHERE year ...) failed to merge partial results, ierr = -2
clearing data partition W2eOV
clearing data partition WVeO
clearing data partition Z1mMt
filter::sift2S(SELECT hour,sum(in_bytes) FROM 56 data partitions WHERE year
...) -- duration: 0.004001 sec(CPU), 0.00199199 sec(elapsed)
Freeing selectClause @ 0xbf8e1880
tableSelect:: select(hour,sum(in_bytes), year='2012') failed on table T-00
seems that merging partitions when we use category fields raises error.
Is there any way to avoid querying hours of day one by one to get this output
result ?
ibis -d /var/fbdata/2012/02/06 -q "select hour,sum(in_bytes) where
year='2012'"
H1,SUM1
H2,SUM2
H3,SUM3
Regards,
Hassan Hamzehlooee Monfared
Directing Manager
Imen Rayaneh Shargh Co. Ltd.
Tel : +9821 88104832
Cell Phone: +98912 2973770
Web site : http://www.imenrayaneh.com
Please consider the environment before printing this email.*
_______________________________________________
FastBit-users mailing list
[email protected]
https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
