[DRILL-1471] Hbase queries fail with / by zero

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.6.0
• Component/s: Storage - HBase
• Assignee: Aditya Kishore
• Reporter: Krystal
• Created: 30/Sep/14 18:48
• Updated: 20/Apr/15 22:13
• Resolved: 30/Sep/14 19:15

Description

git.commit.id.abbrev=81fb18a

The following hbase query fails:
0: jdbc:drill:schema=dfs> select cast(row_key as integer) voter_id, convert_from(onecf['name'], 'UTF8') name, cast(twocf['age'] as integer) age, cast(twocf['registration'] as varchar(20)) registration, cast(threecf['contributions'] as decimal(6,2)) contributions, cast(threecf['voterzone'] as integer) voterzone,cast(fourcf['create_date'] as timestamp) create_date from M7.m7voter where onecf['name'] not similar to '%(young|u|a|i|e|m)%';
Query failed: Failure while setting up Foreman. / by zero [176bbea0-b240-4ed2-88a6-b0e707c0e442]

Issue Links

• duplicates: DRILL-1433 Where query on HBase store fails when row_key doesn't exist in HBase