Community Articles

Find and share helpful community-sourced technical articles.
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Labels (1)
avatar

PROBLEM:

For example, while running from shell, we usually append the single quotes around the date type:

hive> select * from students where datestamp='2014-09-23'; 
OK
fred flintstone351.282014-09-23 
Time taken: 0.761 seconds, 
Fetched: 1 row(s) 

But in case of Hue, internally it doesn't append these single quotes and throws error on browse data.

STEPS TO REPRODUCE:

1. Create table:

CREATE TABLE students(name varchar(64), age int, gpa decimal(3,2)) PARTITIONED BY ( datestamp date);

2. Insert:

INSERT INTO TABLE students PARTITION (datestamp = '2014-09-23') VALUES ('fred flintstone', 35, 1.28);

3. Login into hue -> Go to HCatalog -> Tables -> select 'students' -> Click on Browse data

4. This will generate error:

17610-hueerror.png

RESOLUTION: There is an internal bug reported. Please reach out to support.

555 Views