Thank you all for the responses - turns out ` didn't work as an escape key
either and we had to rewrite the data with _ . Much appreciated!
Alex
On Thu, May 31, 2012 at 11:03 AM, shrikanth shankar wrote:
> I believe Hive column names cant have '-' in them . From what I know this
> JSON serde uses
I believe Hive column names cant have '-' in them . From what I know this JSON
serde uses column names as JSON expressions. This means that if you renamed the
column name you would end up with a null value for the column. You might want
to try a different json serde (for e.g. the one Amazon use
I never use - for variable names or object names. Makes trouble for
ORM tools package names etc etc. _ is your friend. I believe the
correct escape here is backtick `. But you might be out of luck.
On 5/31/12, Alex Barrera wrote:
> Hi there,
>
> I'm looking for help with the following error: I ke
Hi,
try to use _ instead -
UA_Platform STRING,
and so on.
- Alex
--
Alexander Alten-Lorenz
http://mapredit.blogspot.com
German Hadoop LinkedIn Group: http://goo.gl/N8pCF
On May 31, 2012, at 5:35 PM, Alex Barrera wrote:
> Hi there,
>
> I'm looking for help with the following error: I keep r
Hi there,
I'm looking for help with the following error: I keep receiving an error
'Parse Error: line 40:4 cannot recognize input near '-' 'Platform' STRING
column type. '
It looks to be a problem with my JSON deserializer OR Hive not recognizing
the - in the field names. So far I've tried commen
