Re: Data are not displayed correctly on hive tables

2012-05-08 Thread Mark Grover
Grover, Business Intelligence Analyst OANDA Corporation www: oanda.com www: fxtrade.com - Original Message - From: "mperformer" To: user@hive.apache.org Sent: Tuesday, May 8, 2012 6:22:03 PM Subject: Re: Data are not displayed correctly on hive tables Hi Mark Thanks for

Re: Data are not displayed correctly on hive tables

2012-05-08 Thread mperformer
at it is expected to be? > > Good luck! > Mark > > Mark Grover, Business Intelligence Analyst > OANDA Corporation > > www: oanda.com www: fxtrade.com > > - Original Message - > From: "mperformer" > To: user@hive.apache.org > Sent: Sunday, Ma

Re: Data are not displayed correctly on hive tables

2012-05-07 Thread Mark Grover
ct: Re: Data are not displayed correctly on hive tables Hi Mark Many thanks for your reply. Please find the below output. hive> describe formatted messagetemplate; OK # col_name data_type comment messagetemplateid bigint None messagetemplatename string None datacol string None messaget

Re: Data are not displayed correctly on hive tables

2012-05-06 Thread mperformer
Hi Mark Many thanks for your reply. Please find the below output. hive> describe formatted messagetemplate; OK # col_name data_type comment messagetemplateid bigint None messagetemplatename string None datacol

Re: Data are not displayed correctly on hive tables

2012-05-06 Thread Mark Grover
Could you share the output of the following command in Hive: describe formatted messagetemplate My hunch is that your Hive table is using a delimiter (e.g. '\t') that appears in the content of your XML. Mark Grover, Business Intelligence Analyst OANDA Corporation www: oanda.com www: fxtrade.co