title: Combine few hbase shell commands
body: <p>I have a hbase table with 4 columns. I want to search for a string in column1 and get the value of column2 from every row, where I get a match. I works with these two codelines</p>
  
  <p><strong>scan 'table', { COLUMNS => 'column1', FILTER => "ValueFilter(=, 'substring:value')"}</strong></p>
  
  <p>Then foreach row: <strong>get 'table', $row, {COLUMNS => 'column2'}</strong></p>
  
  <p>How can I get the result (e.g. 'value1, value2, value3') by executing only one command?</p>
  
  <p>best regards
  n3</p>