title: How to do cross join between two H2OFrame in R?
body: <p>I want to  do cross join between two H2OFrames. Looking for work around <strong>Strictly in H2OFrame</strong></p>
  
  <pre><code>col1.1 &lt;- c('A', 'B', 'E', 'C', 'F', 'D')
  dummy &lt;- rep(1,6)
  
  d1.hex &lt;- as.h2o( cbind( col1.1, dummy ) )
  
  col2.1 &lt;- c('xx', 'yy', 'zz', 'ww')
  
  dummy &lt;- rep(1,4)
  
  d2.hex &lt;- as.h2o( cbind( col2.1, dummy ) )
  </code></pre>
  
  <p>If I use <code>all =TRUE</code> it throws Error : unimplemented</p>
  
  <pre><code>h2o.merge(d1.hex, d2.hex, all = TRUE)
  </code></pre>
  
  <p>If I use default, joining result is not cross join</p>
  
  <pre><code>h2o.merge(d1.hex, d2.hex )
  </code></pre>
  
  <blockquote>
    <p>dummy col1.1 col2.1</p>
    
    <p>1      A     xx</p>
    
    <p>1      B     xx</p>
    
    <p>1      E     xx</p>
    
    <p>1      C     xx</p>
    
    <p>1      F     xx</p>
    
    <p>1      D     xx</p>
  </blockquote>
  
  <p>I have tried changing data types of joining column to categorical or numeric but no success. Looking for your help in resolving the issue.</p>
  
  <p>Thank you</p>