<div>
Are you talking about the Windows registry hive or some other database?<br />
<br />
What language are you using?
</div>


Are you talking about the Windows registry hive or some other database?

What language are you using?

<div>
In looking at the Hive language manual it uses fairly standard SQL<br />
<br />
SELECT * FROM sales WHERE amount &gt;&nbsp;10 AND region = &quot;US&quot;<br />
<br />
Link to the language manual<br />
<a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual" rel="ugc">https://cwiki.apache.org/confluence/display/Hive/LanguageManual</a><br />
<br />
mlmcc
</div>


In looking at the Hive language manual it uses fairly standard SQL

SELECT * FROM sales WHERE amount > 10 AND region = "US"

Link to the language manual
https://cwiki.apache.org/confluence/display/Hive/LanguageManual [https://cwiki.apache.org/confluence/display/Hive/LanguageManual]

mlmcc

<div>
My guess would be some combination of ClusterBy and Transform, however, I have no way to test this.
</div>


My guess would be some combination of ClusterBy and Transform, however, I have no way to test this.

<div>
<div class="content wysiwyg-content">
I have a table in hive:<br />
table1<br />
f1 &nbsp;f2<br />
x &nbsp; 10<br />
y 20<br />
p 40<br />
q 55<br />
<br />
How can I query the above table in hive to obtain one record like the following:<br />
x:10, y:20, p:40, q:55<br />
<br />
Thank you.
</div>
</div>


I have a table in hive:
table1
f1  f2
x   10
y 20
p 40
q 55

How can I query the above table in hive to obtain one record like the following:
x:10, y:20, p:40, q:55

Thank you.

Hive query question

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.