About ponypony

ponypony · ‎08-10-2017

Hi, I have some queries are slow in impala (such as min/max), if I post the profile here, can someone help pointing out some the issues? Thanks Shannon

ponypony · ‎08-01-2017

Thanks i was doing something for short term, worked.

ponypony · ‎07-28-2017

Hi Is it possible to have two external tables point to the same hdfs location? Thanks Shannon

ponypony · ‎07-25-2017

Thanks!

ponypony · ‎07-25-2017

Hi, If i create index in hive, does it help running queries in impala? Thanks Shannon

ponypony · ‎07-20-2017

Hi, I have this very weird issue, using sqoop to pulling data from oracle to hdfs/hive, i have three jobs running, total records is 312,163,901, but it stops at 312,160,000, the jobs show as running, but it hangs and nohting in the log and no update. A different table works fine. To me somehow the last 3901 got stuck, can someone help or give some hints? Thanks Shannon

ponypony · ‎06-20-2017

Thanks

ponypony · ‎06-19-2017

Thanks. I have a related question, how does hdfs/impala know that one of the fields/columns is used as the partition? Shannon

ponypony · ‎06-13-2017

Thanks. Sorry i was not clear when i said diffference, i meant is there any performance difference?

ponypony · ‎06-13-2017

Is it possible to get array data by position? If B is an array under A, can i do something like select B[0].value, B[1].value from A Thanks Shannon

Online	Offline
Last Visited	‎10-03-2017 12:21 PM

Member Since	‎09-14-2016 10:37 AM
Last Visited	‎10-03-2017 12:21 PM
Posts	116
Kudos received	2

Cloudera Community

Re: Two external tables point to same hdfs locatio...

Impala max/min slow

Re: Two external tables point to same hdfs locatio...

Two external tables point to same hdfs location

Re: sqoop stuck at the end

hive index on impala

sqoop stuck at the end

Re: query on partition question

Re: query on partition question

Re: query on partition question

Query array value by index/posistion