Formula in db extracting distinct values

Hi,

I'm trying to pull distinct values from a table in HIVE . First, I made the connection with 'connect In-DB' (no problems here), then I used 'formula in db' to pull distinct values for name.

I use ---- SELECT DISTINCT name FROM x_t1, but it seems to giving me an error. What am I doing wrong? x_t1 table is under a different folder if it makes any difference.

Thanks

Database Connection

Accepted answers

DataBlender

Hi @fomenter,

I'd suggest entering the query directly into the connect in-db query box rather than the in-db formula tool.

All comments

DataBlender

Hi @fomenter,

I'd suggest entering the query directly into the connect in-db query box rather than the in-db formula tool.

dsemitekol

Hi,

Trying to accomplish the same thing. However, I want to apply the "select distinct" halfway through my workflow, not at the begging. I'm trying to use the In-DB Filter tool but am also pulling an error. Any help on the syntax?

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335