Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Bug length value duplicated

Highlighted

Bug length value duplicated

Explorer

Hi everyone,

 

I'm impala developer, i need some help about impala issues, I'm using Impala 1.4 with CDH 5.1.2.


I'm working on a view X, every FIELD is String datatype.

 

When i'm trying to run this code:
select length(FIELD) from view X;

The result is 4 for example.

 

A part of the content of the field is "\0". This means a NULL value.

For example if i try to run this query : select count(FIELD) from X where FIELD like '%\0%'
The result of the count is N.

 

When i'm trying to materialize this view, the length of a specified field is duplicated.

I mean,when i run this query:
select length(FIELD) from materialize view x
the result is 8, wich is exactly 4*2...XD

 

This miss probabily that Impala is duplicating the legnth of that string in the materialized view.

 

I don't know why.

I need some help about this issues,
Thank you very much

Alberto

1 REPLY 1

Re: Bug length value duplicated

Master Collaborator

Hi Alberto,

 

I'm not sure I followed the issue completely. Would you be able to post a more detailed CREATE TABLE and CREATE VIEW? Even better, a step-by-step sequence of DDL/queries that show the problem. 

 

Thanks!

 

Alex