Question: So I have a CF whose Schema looks something like this :

```
CREATE TABLE "emp" (
id text,
column1 text,
column2 text,
PRIMARY KEY (id, column1, column2)
)

```

I have an entry which looks like this and I want to delete it :

```
20aff8144049 | name | someValue

```

So i tried this command :

```
Delete column2 from emp where id='20aff8144049';

```

It failed with below error:

no viable alternative at input '20aff8144049' (...column2 from emp where id=["20aff8144049]...)

Can someone help with where I'm going wrong? Thanks!

Answer: 
> 
> Subscription Upgrade/Downgrade
> 
> 
> 

With the In-app Billing API, users can upgrade or downgrade a subscription during its active period. When the user does this, the active subscription is canceled and a new subscription is created. ***The unused balance of the old subscription is applied on a pro-rated basis to the new subscription.*** The first billing period for the new subscription begins after that balance is used up.

> 
> Subscription Cancellation
> 
> 
> 

Users can view the status of all of their subscriptions and cancel them if necessary from the My Apps screen in the Play Store app. Currently, the ***In-app Billing API does not provide support for programmatically canceling subscriptions*** from inside the purchasing app.

In addition to client-side API calls, you can use the server-side API for [cancelling a subscription](https://developers.google.com/android-publisher/api-ref/purchases/subscriptions/cancel) programattically. This call cancels a user's subscription purchase but remains valid until its expiration time.
<https://developer.android.com/google/play/billing/billing_subscriptions.html>

please read the 6th point, user wont be charged 2nd time as per android Documentation, read below. 

> 
> Users can upgrade or downgrade a subscription in the middle of a
>  subscription period. The old subscription's cost is pro-rated, and the
>  unused portion is applied to the replacement subscription.
> 
> 
>