Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Message-ID: <BLU436-SMTP1975C1878CC7C2C883DFDE092B10@phx.gbl>
Subject: Re: Field delimiter in hive
References: <BLU436-SMTP2473AF840CFEBAE576840E792BD0@phx.gbl>
To: "user@hive.apache.org" <user@hive.apache.org>
From: mahender bigdata <Mahender.BigData@outlook.com>
Date: Mon, 7 Mar 2016 12:32:57 -0800
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.6.0
MIME-Version: 1.0
In-Reply-To: <BLU436-SMTP2473AF840CFEBAE576840E792BD0@phx.gbl>
Content-Type: multipart/alternative;
	boundary="------------060006020502030101080907"

--------------060006020502030101080907
Content-Type: text/plain; charset="utf-8"; format=flowed
Content-Transfer-Encoding: quoted-printable

Any help on this.

On 3/3/2016 2:38 PM=2C mahender bigdata wrote:
> Hi=2C
>
> I'm bit confused to know which character should be taken as delimiter=20
> for hive table generically. Can any one suggest me best Unicode=20
> character which doesn't come has part of data.
>
> Here are the couple of options=2C Im thinking off for Field Delimiter.=20
> Please let me know which is best one use and chance of that character=20
> ( i.e delimiter ) in data is less in day to day scenario..
>
> \U0001 =EE=80=81 =3D START OF HEADING =3D=3D> SOH  =3D=3D> ( CTRL+SHIFT+A=
 in windows) =20
> =3D=3D> Hive Default delimiter
>
>
> _\U001F =EE=80=9F __=3D INFORMATION SEPARATOR ONE =3D unit separator (US)=
  =3D> __(=20
> CTRL+SHIFT+ - in windows)_
>
>
> _\U001E =EE=80=9E __=3D INFORMATION SEPARATOR TWO =3D record separator (R=
S) =3D=3D>=20
> __( CTRL+SHIFT+6 in windows)_
>
> Some how by name i feel \U001F is best option=2C can any one comment or=20
> provide best Unicode which doesn't in regular data.
>
>
>


--------------060006020502030101080907
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta content=3D"text/html=3B charset=3Dutf-8" http-equiv=3D"Content-Ty=
pe">
  </head>
  <body bgcolor=3D"#FFFFFF" text=3D"#000000">
    Any help on this.<br>
    <br>
    <div class=3D"moz-cite-prefix">On 3/3/2016 2:38 PM=2C mahender bigdata
      wrote:<br>
    </div>
    <blockquote
      cite=3D"mid:BLU436-SMTP2473AF840CFEBAE576840E792BD0@phx.gbl"
      type=3D"cite">
      <meta http-equiv=3D"content-type" content=3D"text/html=3B charset=3Du=
tf-8">
      Hi=2C<br>
      <br>
      I'm bit confused to know which character should be taken as
      delimiter for hive table generically. Can any one suggest me best
      Unicode character which doesn't come has part of data.<br>
      <br>
      Here are the couple of options=2C Im thinking off for Field
      Delimiter. Please let me know which is best one use and chance of
      that character ( i.e delimiter ) in data is less in day to day
      scenario..<br>
      <br>
      \U0001 =EE=80=81 <control> =3D START OF HEADING =3D=3D&gt=3B SOH=C2=
=A0 =3D=3D&gt=3B (
        CTRL+SHIFT+A in windows)=C2=A0 =3D=3D&gt=3B Hive Default delimiter<=
br>
        <br>
      </control><br>
      <u>\U001F =EE=80=9F </u><u><control> =3D INFORMATION SEPARATOR ONE =
=3D unit
          separator (US)=C2=A0 =3D&gt=3B </control></u><control><u>( CTRL+S=
HIFT+
          - in windows)</u><br>
        <br>
      </control><br>
      <u>\U001E =EE=80=9E </u><u><control> =3D INFORMATION SEPARATOR TWO =
=3D record
          separator (RS) =3D=3D&gt=3B </control></u><u> ( CTRL+SHIFT+6 in
        windows)</u><br>
      <br>
      Some how by name i feel \U001F is best option=2C can any one comment
      or provide best Unicode which doesn't in regular data.<br>
      <br>
      <br>
      <br>
    </blockquote>
    <br>
  </body>
</html>

--------------060006020502030101080907--