Hi,
Could some one suggest how to create surrogate keys sequentially in hive ?
--
Thanks,
Kishore.
metastore.
16/11/28 21:21:46 ERROR tool.ImportTool: Imported Failed: Cannot convert
unsupported type: timestamp
Thanks,
Kishore Kumar.
--
Thanks,
Kishore.
Hi Hive Users,
Using hive 1.2 version,
I am connecting hiveserver2 via jdbc connection, could any one suggest me
how to configure log file
using this link
https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients
I set these 3 parameters values
- hive.server2.logging.operation.enabl
Hi,
If i run "select * from table"
permission denied error we are encountering, where as
select * from table limit 10; or
select count(*) from table;
working fine, what could be the reason any guess ?
--
Thanks,
Kishore.
facing is
OK
FAILED: SemanticException [Error 10098]: Non-Partition column appears
in the partition specification: col1
Please help me what I am missing.
--
*Kishore Kumar*
ITIM
Hi All,
My input data looks like below as | delimited and I want to extract appid,
appname, bundleid etc, please help me to create hive table ,
|0|{\x22appid\x22:\x228\x22,\x22appname\x22:\x22CONVX-0008\x22,\x22bundleid\x22:\x22com.zeptolab.timetravel.free.google\x22}|14|
-- Thanks,
*Kishore *
some part of the line is storing in one block, and rest of the line is
storing in another block, when i query for column one hive is giving the
first column as the first column in another block(which begins from middle
of the line).
On Tue, Apr 29, 2014 at 2:05 PM, Kishore kumar wrote:
>
&
Hi All,
My input data contains 45 columns, when I stored the data in hive table,
end of the line in a block storing part of the line, so when I query its
giving wrong result, please help me to store the full line in a block.
-- Thanks
*Kishore *
Hi,
I am using cloudera4.5 with cloudera manager4.8, I want to set
hive.cli.print.header=true, where should i specify, is it possible to
specify in CM, or from cli what is location, please help me.
-- Thanks,
*Kishore *
Hi All,
I heard about the reduce job, it will be started after all map tasks
finished 100%, but in my hive query the reduce job started at below stage,
please explain why is this.(I copied below line when the job is running).
2014-04-22 21:15:12,803 Stage-1 map = 83%, reduce = 1%, Cumulative CPU
e. See it anyway? y
when i enter "y" the result is
0^A0^A0^A11^A0^A12^A416^A0.0
0^A0^A0^A11^A38^A12^A87^A0.0
0^A0^A0^A12^A53^A11^A1^A0.0
0^A0^A0^A12^A72^A11^A30^A0.0
0^A0^A0^A12^A357^A11^A12^A0.0
0^A0^A0^A12^A395^A11^A2^A0.0
0^A0^A0^A12^A547^A11^A9^A0.0
On Tue, Apr 22, 2014 at 8:
Hi Experts,
Hive query result stored in hdfs with 75 zip files, I merged them and get
into the local filesystem with '-getmerge', but I am unable to see the data
after i unzipped the file, anything i am missing ? please help me.
--
*Kishore *
With the same credentials I am able to download the s3 file to my local
filesystem.
On Tue, Apr 22, 2014 at 11:17 AM, Kishore kumar wrote:
> No, I am running in cli.
>
>
> On Mon, Apr 21, 2014 at 8:43 PM, j.barrett Strausser <
> j.barrett.straus...@gmail.com> wrote:
>
21, 2014 at 11:12 AM, j.barrett Strausser <
> j.barrett.straus...@gmail.com> wrote:
>
>> Hope those aren't you actual credentials.
>>
>>
>> On Mon, Apr 21, 2014 at 11:05 AM, Kishore kumar wrote:
>>
>>> I Edited "Cluster-wide Configuration Safety
ode 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
Thanks,
Kishore.
On Mon, Apr 21, 2014 at 8:17 PM, Kishore kumar wrote:
> I set the credentials from hive command line, still I am getting the
> error. please help me.
>
> hive> set fs.s3.awsAccessKeyId = x;
> hive> set fs.s3.awsSe
On Mon, Apr 21, 2014 at 7:33 PM, Kishore kumar wrote:
> Hi Experts,
>
> I am trying to create table against my s3 file, I faced the below issue,
> where to set these credentials in clouderamanager4.8. I got this link (
> http://community.cloudera.com/t5/Cloudera-Manager-Installation/
Hi Experts,
I am trying to create table against my s3 file, I faced the below issue,
where to set these credentials in clouderamanager4.8. I got this link (
http://community.cloudera.com/t5/Cloudera-Manager-Installation/AWS-Access-Key-ID-and-Secret-Access-Key-must-be-specified-as-the/td-p/495)
aft
Hi Experts,
We are running four node cluster which is installed cdh4.5 with cm4.8, We
have large size files in zip format in s3, we want to analyze that files
for every hour in hive, which is the best way to do that, please help me
with examples or with any reference links.
-- Thanks,
*Kishore
Hi Experts,
After I changed the column names in hive table,m the result showing all
null values with new column names, if i query with select * from table
giving the actual values result, what could be the problem please explain
what should i do now, help me.
-- Thanks,
*Kishore *
and will do
>
> On 1/9/14, Kishore kumar wrote:
> > No I want to change 4to5 columns only outof 40 columns.
> >
> >
> > On Wed, Jan 8, 2014 at 2:05 PM, Edward Capriolo
> > wrote:
> >
> >> Alter table replace columns changes all columns and types.
No I want to change 4to5 columns only outof 40 columns.
On Wed, Jan 8, 2014 at 2:05 PM, Edward Capriolo wrote:
> Alter table replace columns changes all columns and types.
>
>
> On Wed, Jan 8, 2014 at 5:35 AM, Kishore kumar wrote:
>
>> Hi Experts,
>>
>> Is there
Hi Experts,
Is there a way to change multiple column names and types ?
--
*Kishore Kumar*
ITIM
How to create partitioned table without creating intermediate table?
simply..
On Tue, Jan 7, 2014 at 10:21 AM, Nitin Pawar wrote:
> can you put your question in with an example?
>
>
> On Tue, Jan 7, 2014 at 2:43 PM, Kishore kumar wrote:
>
>> Hi Experts,
>>
>&g
partitioned table.
--
*Kishore Kumar*
24 matches
Mail list logo
