Member since
04-12-2018
10
Posts
0
Kudos Received
0
Solutions
12-27-2018
11:10 AM
Hi Hao THe query does not compile in Impala Shell. Impala is unable to parse LATERAL VIEW EXPLODE
... View more
12-27-2018
03:25 AM
Hi Hao, The source "database" is on another cluster and the destination on a different cluster. can I run something like insert into cluster2DB.table select * from cluster1DB.table ?
... View more
12-27-2018
03:22 AM
Hi Hao, I am using HUE via browser. Also tried hive and beeline commandline utilities. Same error in all 3 instances.
... View more
12-26-2018
11:15 AM
I get the following error when trying to insert data into a kudu table Error while compiling statement: FAILED: RuntimeException java.lang.ClassNotFoundException: org.apache.kudu.mapreduce.KuduTableOutputFormat insert into db.my_kudu_table select ..... from db.another_table
... View more
Labels:
- Labels:
-
Apache Kudu
12-26-2018
09:32 AM
Is it possible to load a kudu table with data from kudu table in another database? Both tables have same structure. It it possible to do a cross-db import?
... View more
Labels:
- Labels:
-
Apache Kudu
04-26-2018
12:49 PM
Trying to create a dataframe like so kuduOptions = {"kudu.master":"my.master.server", "kudu.table":"myTable"} df = sqlContext.read.options(kuduOptions).kudu The above code is a "port" of Scala code. Scala sample had kuduOptions defined as map. I get an error stating "options expecting 1 parameter but was given 2" How do you connect to Kudu via PySpark SQL Context?
... View more
Labels:
- Labels:
-
Apache Kudu
04-12-2018
04:08 AM
I used
ALTER TABLE old_name RENAME new_name;
ALTER TABLE new_name SET TBLPROPERTIES('kudu.table_name', 'new_name')
to rename an existing table. Things seem to work fine. I was able to run queries on the new_name table
However, my Kafka connector was unable to see the new table. Error said cant find impala::myDB.new_name
via Impala command line issued
describe extended new_name;
The kudu.table_name property displayed as 'new_name' without any of the impala or db qualifiers. Assumed that was the issue and ran
ALTER TABLE new_name SET TBLPROPERTIES('kudu.table_name', 'impala::myDB.new_name')
The above timed out and now I am unable to run queries against new_name
Show tables lists the table but describe or any other query says table not found.
... View more
Labels:
- Labels:
-
Apache Impala
-
Apache Kafka
-
Apache Kudu