Hi,   Can I create a parameterized view in impala   somethig like the below pseudo code:   Create View MyView      as      SELECT col1, col2 col3      FROM table_one      WHERE startdate = ${date1}      and enddate         = ${date2}      ...       ... View more

we need to partition our Hive Table based on date. Date/Month/Year   is it better to use int or string for the partition types. ex: CREATE EXTERNAL TABLE partition (id string, event timestamp and so on) PARTITIONED BY (year INT, month INT, day INT) Stored as Parquet vs   CREATE EXTERNAL TABLE partition (id string, event timestamp and so on) PARTITIONED BY (year string, month string, day string) Stored as Parquet   Noticed that we couldn't do queries like: ... where day > 10 with the string option ... View more

  Can we take advantage of Hive table partitions when querying with impala   Are there any issues or problems we might run into given this scenario.   We currently have partitioned hive tables... will we be missing anything if we dont convert to impala tables ... View more

Hi,   I need to retrieve only the last entry in a given partition if there are multiple entries therein   Assume I create an external table partitioned by date: create external table test_lb (field1 string, field2 string, field3 string)   partitioned by (year string, month string , day string, host string)   row format delimited fields terminated by ',' Then I insert multiple records to same partition. i,e. same year,month,day insert into test_lb partition (year="2013", month="07", day="28") values ("foo1", "FOO2", "FOO3"); insert into test_lb partition (year="2013", month="07", day="28") values ("foo4", "FOO5", "FOO6");   How do I retrieve just the most recent entry via a query... is there an inbuilt way to get only the latest values ... View more

Hi I am trying to install cloudera manger on RHEL 7   I keept getting this error.   I have tried local repository and I get same thing   oracle-j2sdk1.8 installation failed. See /var/log/cloudera-manager-installer/1.install-oracle-j2sdk1.8.log for details. Click OK to revert this installation.   Error from Log: ---------------------- Loaded plugins: langpacks, product-id, search-disabled-repos, subscription- : manager Resolving Dependencies --> Running transaction check ---> Package oracle-j2sdk1.8.x86_64 0:1.8.0+update141-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: oracle-j2sdk1.8 x86_64 1.8.0+update141-1 cloudera-manager 176 M Transaction Summary ================================================================================ Install 1 Package Total download size: 176 M Installed size: 359 M Downloading packages: No Presto metadata available for cloudera-manager https://archive.cloudera.com/cm6/6.1.0/redhat7/yum/RPMS/x86_64/oracle-j2sdk1.8-1.8.0%2Bupdate141-1.x86_64.rpm: [Errno 14] curl#56 - "SSL received a record with an incorrect Message Authentication Code." Trying other mirror. Error downloading packages: oracle-j2sdk1.8-1.8.0+update141-1.x86_64: [Errno 256] No more mirrors to try. ... View more

I got this error while trying to install Cloudera manager on my Rhel7 workstation   Loaded plugins: langpacks, product-id, search-disabled-repos, subscription- : manager Resolving Dependencies --> Running transaction check ---> Package oracle-j2sdk1.8.x86_64 0:1.8.0+update141-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: oracle-j2sdk1.8 x86_64 1.8.0+update141-1 cloudera-manager 176 M Transaction Summary ================================================================================ Install 1 Package Total download size: 176 M Installed size: 359 M Downloading packages: No Presto metadata available for cloudera-manager [Errno 14] curl#56 - "SSL received a record with an incorrect Message Authentication Code." Trying other mirror.   ... View more