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.

Impala Column Name convention Issue

Highlighted

Impala Column Name convention Issue

New Contributor

Hi All,

 

We are facing a problem with Imapla Column naming convention which seems unclear to us.

 

The CDH imapala documentation (http://www.cloudera.com/documentation/archive/impala/2-x/2-0-x/topics/impala_identifiers.html) 3rd bullet point says : An identifier must start with an alphabetic character. The remainder can contain any combination of alphanumeric characters and underscores. Quoting the identifier with backticks has no effect on the allowed characters in the name.

 

Now, due to dependency with the upstream SAP systems, we had to name a column name starting with (0) zero as numeric. While defining and extracting the records from the table impala does not show any semantic error. While connecting Imapala with SAP HANA through SDA (Smart Data Access), the extraction is failing for this particular column which is starting with a leading zero (0) and fine for rest of the columns which are starting with an alphabet. The error shows as "... ^ Encountered: DECIMAL LITERAL "

 

I have to points.

 

  1. If the documentation says, an identifier can not start anything other that alphabet, then how the imapla query is running without any issues.
  2. Why the error is only raised while it is getting extracted from SAP HANA.

 

Any insight will be highly appreciable.

 

 

Best,

Murari

1 REPLY 1
Highlighted

Re: Impala Column Name convention Issue

Contributor
Can you show the command you used in which you "defin[ed] and extract[ed] the records from the table [with] impala" during which it did not show any semantic error?

Generally, if a feature (such as numeral-prefixed column names) is unsupported, I would not expect that nothing related to that feature will ever halfway work or just work poorly. I try not to depend on unsupported features working.
Don't have an account?
Coming from Hortonworks? Activate your account here