cross table

[#1]

Hi,
i m making a dashboard from hive table.
i need to make a cross table.
i have tried the following command

CrossTable(sentiment_category, sentiment_score )
LOAD Key,
actor,
bond_girl,
car,
director,
Resident Main;

but it does not work.

kindly help

Regards teja.

[#2]

Hi Teja,

Can you upload a sample qvw.

[#3]

Hi,

Can you provide sample input and sample output for the same?

It will help to provide you exact solution.

Regards,

Amay

[#4]

hi,

please find the attachment for sample data.

Regards,

Teja

[#5]

And how would be output of this?

Regards,

Amay

[#6]

hi,

My output should contain a list box in which all those category names like actor,joker,villian should appear together.

please find the attachment.

Regards

teja.

[#7]

Hi,

Maybe you use this

Crosstable(Category,Score,21)

LOAD

*

from test.xls;

I didnt test this.

Regards,

Amay

[#8]

Hi

use the inline load

category as field and

give actor,car,director,... as field values

here we give fileds as category field values

[#9]

Hi,

Its working well but our requirement is to connect that category table to remaining other tables through key for that we r using cross table. If u know any means by which we can connect the inline table with other tables through a key it would be helpful.

Regards,

Tejavardhan.

[#10]

Teja,

Attach a sample document with the inline data.

Thanks,

Sampath

[#11]

hi sampath,

In the above replies i have attached the excel file which contains the data loaded in hive

Regards,

Tejavardhan