title: Hadoop Hive - Split string
body: <p>I am a new hivebe.</p>
  <p><strong>My Query :</strong> In the log file we have a request field like this &quot;GET /img/home/search-user-ico.jpg HTTP/1.1&quot; .There are more than 10,000 records are available.</p>
  <p><strong>Example :</strong></p>
  <p>&quot;GET /img/home/search-user-ico.jpg HTTP/1.1&quot;<br />
  &quot;GET /JavaScript/jquery-1.4.2.min.js HTTP/1.1&quot;
  &quot;GET /ems/home HTTP/1.1&quot;
  &quot;POST /ir HTTP/1.1&quot;
  &quot;GET /CSS/jquery/themes/base/jquery.ui.button.css HTTP/1.1&quot;
  &quot;GET /CSS/jquery/themes/base/images/ui-bg_glass_75_e6e6e6_1x400.png HTTP/1.1&quot;<br />
  &quot;GET /JavaScript/jquery/jquery-ui-1.8.5.custom.min.js HTTP/1.0&quot;</p>
  <p>From this field &quot;GET /img/home/search-user-ico.jpg HTTP/1.1&quot;  , i want only this part <strong>/img/home/search-user-ico.jpg</strong> ,i want to split it from GET,POST and HTTP/1.1 so please help me as how to split this using string functions available in wiki.I tried with some of the syntax available in wiki.but i'm helpless now.</p>
  <p>i tried with the syntax like,</p>
  <p>select regexp_extract(request,'a-zA-Za-zA-Z[a-zA-Z]',2) from logfile limit 10;</p>
  <p>select regexp_extract(request,'GET(\s)([a-zA-Z])',2) from logfile limit 10;</p>
  <p>select regexp_extract(request,'.<em>?(\s)(.</em>?)(\s)(.*?)',2) from logfile limit 10;</p>
  <p>select regexp_extract(request,'.<em>(\s)(.</em>)(\s)(.*)',2) from logfile limit 10;</p>
  <p>Thanks
  -Joe</p>