Hi, I created a test table in HBASE with 2 column families [‘cf0’, ‘cf1’] and 3 columns for each, all same value, 100,000 rows in total.
SELECT COUNT(*) will not return the correct row count (much less, a few thousands). However, doing SELECT on a subset of those columns gives the right count. If I reduced the column number to 2 in this case, SELECT COUNT(*) gives the right count. Later I tried tables with only one column family, drill returns the right count only when column number < 6. What could be the explanations of this matter? Have I missed any drill configurations? Carrot Hu, 胡意仪 R&D Engineer Tech BU [cid:[email protected]] a Kantar Media Company [cid:[email protected]]T: +86 (21) 5237 3860 ext. 8704 | F: +86 (21) 5237 3632 Email/MSN: [email protected]<mailto:[email protected]> A: Floor 4, Building 6, Fenglin Link, No.485 Feng Lin Road, Xuhui District, Shanghai, 200032, China Corp. Website: www.ciccorporate.com<http://www.ciccorporate.com/> | Service Platform: www.iwommaster.com<http://www.iwommaster.com/> | Corp. Blog: www.seeisee.com<http://www.seeisee.com/> Weibo: @seeisee<http://weibo.com/seeisee> | Wechat: seeiseeCHAT | Facebook: facebook.com/CICcorporate<http://www.facebook.com/CICcorporate> 免责声明：本信函为可能包含机密信息的非公开文件。如果阁下非信函所指定之收件人，谨请立即通知发件人，并敬请阁下不要使用、保存、复印、散布信函内容，或将其用于其他任何目的或向任何人披露。谢谢您的合作.DISCLAIMER: This e-mail and any file transmitted with it are confidential and may contain legally privileged information. If you are not the intended recipient, you are hereby notified that any use, disclosure, copying, dissemination of, or taking any action in reliance on this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately inform us by returning e-mail, and thereafter, proceed to permanently delete the entire e-mail sent in error. Thank you.
