Member since
11-05-2018
32
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
3178 | 07-10-2019 04:37 AM |
11-27-2019
11:03 PM
I use CDH6.2. impala-shell --version Impala Shell v3.2.0-cdh6.2.0 (edc1994) built on Thu Mar 14 00:14:35 PDT 2019 kudu --version kudu 1.9.0-cdh6.2.0 revision b4310ca4289bd207fd5b32f5fe001609b4093c27 build type RELEASE built by jenkins at 14 Mar 2019 00:03:44 PST on cldrn-ub1604-ec2-c5d-18xlarge-spotblk-0c10.vpc.cloudera.com
... View more
11-27-2019
09:50 PM
Hi, I'm trying to create Kudu table from impala. My Kudu instance is integrated with HMS (at least kudu hms check and precheck does not show any issues), but when I'm trying to create new table I have error as below: CREATE TABLE my_first_table (id BIGINT, name STRING, PRIMARY KEY(id)) PARTITION BY HASH PARTITIONS 16 STORED AS KUDU TBLPROPERTIES ('kudu.num_tablet_replicas' = '1'); Query: CREATE TABLE my_first_table (id BIGINT, name STRING, PRIMARY KEY(id)) PARTITION BY HASH PARTITIONS 16 STORED AS KUDU TBLPROPERTIES ('kudu.num_tablet_replicas' = '1') ERROR: ImpalaRuntimeException: Error creating Kudu table 'impala::default.my_first_table' CAUSED BY: NonRecoverableException: an error occurred while creating table impala::default.my_first_table in the HMS: when the Hive Metastore integration is enabled, Kudu table names must be a period ('.') separated database and table name identifier pair, each containing only ASCII alphanumeric characters, '_', and '/': impala::default.my_first_table It looks like table name should meet all name restriction (contains only '_') but kudu claims it does not. I tried to put also table in format <db_name>.<table_name> but no progress. Any advices? Regards, Bart
... View more
Labels:
- Labels:
-
Apache Kudu
08-19-2019
10:03 AM
Hi pollard, Did You try to use Cloudera REST API to do that? Regards, Bart
... View more
08-19-2019
09:59 AM
To be sure that your user have access to warehouse location please try run something like below val warehouseLocation = new File("spark-warehouse").getAbsolutePath
val spark = SparkSession
.builder()
.appName("Spark Hive Example")
.config("spark.sql.warehouse.dir", warehouseLocation)
.enableHiveSupport()
.getOrCreate() Regards, Bart
... View more
07-10-2019
04:37 AM
Hi, Try to not put /default at the end of connection string, because it looks that your user cannot switch to default database during connection. Regards, Bart
... View more
01-16-2019
03:22 AM
To use aes encryption you need to install jce. Be aware also that encryption types on cloudera side should be inline with kerberos server configuration.
... View more