Hi all,
I started Hive Thrift Server with command,
/sbin/start-thriftserver.sh --master yarn -hiveconf
hive.server2.thrift.port 10003
The Thrift server started at the particular node without any error.
When doing the same, except pointing to different node to start the server,
./sbin/start-th
Hi,
I wrote a spark job which registers a temp table
and when I expose it via beeline (JDBC client)
$ *./bin/beeline*
beeline>
* !connect jdbc:hive2://IP:10003 -n ram -p *0: jdbc:hive2://IP>
*show
tables;+-+--+-
HI,
I started a hive thrift server from hive home,
./bin/hiveserver2
opened jdbc client,
./bin/beeline
connected to thrift server,
0: > show tables;
++--+
|tab_name|
++--+
| check |
| people |
+-
Hi,
I have a hbase table with column name changes (increases) over time.
Is there a way to map such hbase to hive table,
inferring schema from the hbase table?
Thanks
Hi,
I have a HBase table with rowkey and column family.
Is it possible to map HBase table to hive table?
Thanks
Hi,
1) created a table in hive,
hive -e "DROP TABLE login1;"
hive -e "CREATE EXTERNAL TABLE login1 (
et STRING,
uuid STRING,
)
ROW FORMAT SERDE 'com.proofpoint.hive.serde.JsonSerde'
LOCATION 's3n://testing/test';"
creating table worked.
--
CREATE EXTERNAL TABLE pick (
ud STRING,
pi ARRAY
>
>>
)
ROW FORMAT SERDE 'com.proofpoint.hive.serde.JsonSerde'
LOCATION 's3n://';
hive> select * from table;
FAILED: SemanticException org.jets3t.service.ServiceException: Request
Error: java.lang.StackOverflowError
hive>
got this exception when fetching from s3
Then i distcp to another s3 path, it works.
It's weird.
when i map the hive table to locate the s3 path,
it throws exception for the* new line at the beginning of line*.
Is there a solution to trim the new line at the beginning in hive?
Or any alternatives?
CREATE EXTERNAL TABLE work (
time BIGINT,
uid STRING,
type STRING
)
ROW
